- A report that contains a table or list to display data from a data set
- One or more report parameters for the report
- 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-14 shows an example of a selected table and its properties.
Figure 12-14 Table properties
- Choose the Filters tab. The property editor displays the Filters page, as shown in Figure 12-15.
Figure 12-15 The Filters page in Property Editor
- Choose Add to create a new filter condition.
- On New Filter Condition, specify the filter condition:
- In the first field, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.
- In the second field, select an operator from the drop-down list.
- 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 that you created for the report, as shown in Figure 12-16.
Figure 12-16 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-17.
Figure 12-17 A filter condition
- Choose OK to save the filter condition.
The filter condition appears on the Filters page in Property Editor, as shown in
Figure 12-18.
Figure 12-18 Filter condition, set to a report parameter
- Preview the report.
Enter Parameters appears and displays the report parameters that you created.
Figure 12-19 shows an example.
Figure 12-19 Enter Parameters, showing a report parameter
- Specify values for the report parameters, then choose OK.
The report displays data that matches the values that you specified.