Adding a parameter to filter web report result

To use the BIRT Report Designer to create a parameter that you can use to filter your report results, complete the following steps. In this example, the License type field is added to the Parameter box for reports that return People records.

1. In the BIRT Report Designer, open the Outline tab.
2. Right-click Report Parameters, and select New Parameter.
3. In the Name field, type a name for the new parameter.
4. In the Data type field, select String.
5. In the Display type field, select Combo Box.
6. In the List of value area, select Static, and click New.
7. In the New Selection Choice dialog box, type Fixed in the Value field, and click OK.
8. Click OK to close the New Parameter box.
9. To create binding between the data set and the new parameter, go to the Data Explorer tab, right-click the appropriate data set, click Edit, click Parameters, and click New.
10. In the New Parameter box, configure the new parameter by completing the following steps:
    1. In the Name field, type the name of the new parameter in the data set.
    2. Select one of the following options because the Default Value field can be edited only if you do not edit the Linked to Report Parameter field:
       • In the Linked To Report Parameter field, select the name of the new parameter you created.

       • In the Default Value field, edit the qualification query of the data set based on the report parameter that you linked to.
         For example, enter the following in the Expression Builder:

         'License Type' = [param:dsLicenseType]

         where dsLicenseType is the data set parameter that refers to the report parameter.

11. Preview the report (save, run, and close the report).
    The Parameter box of the report appears and specifies a fixed License type parameter. The report shows People records having a fixed License type.