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. The property editor displays the properties of the selected table or list.

Figure 12‑5 shows an example of a selected table and its properties.

Figure 12‑5

Table properties

2	Choose the Filters tab. Property Editor displays the Filters page, as shown in Figure 12‑6.

Figure 12‑6

The Filters page in Property Editor

3	Choose Add to create a new filter condition.

4	On 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 12‑7.

Figure 12‑7

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 12‑8.

Figure 12‑8

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 12‑9.

Figure 12‑9

Filter condition set to a report parameter

5	Preview the report.

Enter Parameters appears and displays the report parameters that you created. Figure 12‑10 shows an example.

Figure 12‑10

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.