Previous Next

How to filter at the data set level

1  

Figure 11-1 Edit Data Set displaying the query

Figure 11-1  Edit Data Set displaying the query
2  

Figure 11-2 Edit Data Set displaying filtering information

Figure 11-2  Edit Data Set displaying filtering information
3  
4  
*
*
*
*

Figure 11-3 New Filter displaying a filter condition

Figure 11-3  New Filter displaying a filter condition
Choose OK to save the new filter condition.
5  
To create additional filter conditions for the data set, repeat steps 3 and 4. Figure 11-4 shows two examples of filter conditions created for a data set. Figure 11-5 shows the rows that the data set returns.

Figure 11-4 Edit Data Set displaying the filter conditions for the data set

Figure 11-4  Edit Data Set displaying the filter conditions for the data set
6  
Choose Preview Results to verify the results that filtering the data set returns. If you specified multiple filter conditions, the data set returns only rows that match all filter conditions, as shown in Figure 11-5. To return rows that match any one of the filter conditions, create a single filter condition that contains an OR expression, then select the Is True operator.

Figure 11-5 Preview Results shows only rows that meet both filter conditions

Figure 11-5  Preview Results shows only rows that meet both filter conditions

(c) Copyright Actuate Corporation 2013