How to update a filter condition dynamically when the report runs
This procedure assumes that you already created a report design that contains a table or list to display data from a data set and uses one or more report parameters. This procedure uses the parameter to filter the values that the table displays.
1 In the layout editor, select the table element or list element to filter.
2 In Property Editor, choose the Filters tab.
3 Choose Add to create a new filter condition.
4 In New Filter Condition, specify the filter condition.
1 In the first field, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.
2 In the second field, select an operator from the drop-down list.
3 In the third field, specify the name of the report parameter that you created. You can use the expression builder to select the report parameter from the list of report parameters in the report design, as shown in
Figure 13‑8.
Figure 13‑8 Using the expression builder to select a report parameter
Choose OK to apply the expression to the filter condition. New Filter Condition displays the completed filter condition, as shown in
Figure 13‑9.
Figure 13‑9 A filter condition
4 Choose OK to save the filter condition.
The filter condition appears on the Filters page in Property Editor, as shown in
Figure 13‑10.
Figure 13‑10 Filter condition set to a report parameter
5 Preview the report.
Enter Parameters appears and displays the report parameters that you created.
Figure 13‑11 shows an example.
Figure 13‑11 Enter Parameters showing a report parameter
6 Specify values for the report parameters, then choose OK.
The report displays data that matches the values that you specified.
