Previous Next

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  
2  
3  
4  
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  
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-5.

Figure 12-7 Using the expression builder to select a report parameter

Figure 12-5  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-6.

Figure 12-8 A filter condition

Figure 12-6  A filter condition
4  
The filter condition appears on the Filters page in Property Editor, as shown in Figure 12-7.

Figure 12-9 Filter condition set to a report parameter

Figure 12-7  Filter condition set to a report parameter
5  
Enter Parameters appears and displays the report parameters that you created. Figure 12-8 shows an example.

Figure 12-10 Enter Parameters showing a report parameter

Figure 12-8  Enter Parameters showing a report parameter
6  
The report displays data that matches the values that you specified.

 


(c) Copyright Actuate Corporation 2011