Previous TopicNext Topic


How to filter at the data-set level

  1. In Data Explorer, right-click the data set whose rows you want to filter, then choose Edit. Edit Data Set displays the query for the data set, as shown in Figure 11-1.
  2. Figure 11-1 Edit Data Set, displaying the query
  3. Choose Filters from the left side of the window. Edit Data Set displays filter information, as shown in Figure 11-2.
  4. Figure 11-2 Edit Data Set, displaying filtering information
  5. Specify the filter condition:
    1. Click the cell below Expression. Two buttons appear on the right. The arrow button displays a list of fields you can use in Expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
    2. For Expression, select a field. You can also type the filter expression.
    3. For Operator, select an operator from the drop-down list.
    4. For Value 1, specify the search value. You can type the value, select from the list of values, or use Expression Builder to create a more complex value expression. If you select the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
    5. For Value 2, specify a value only if you select the Between or Not Between operator. Figure 11-3 shows some examples of filter conditions.
    6. Figure 11-3 Filter conditions in Edit Data Set
  6. Choose Preview Results to verify the results that the data set returns. If you specified multiple filter conditions, the report displays only rows that match all filter conditions. To display 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. This task is described later in this chapter.

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic