Previous TopicNext Topic


How to filter at the group level

These instructions assume you already:

 

  1. In the layout editor, select the table that contains the data you want to filter.
  2. In Property Editor, choose the Groups tab.
  3. Property Editor displays the groups you defined for the table.
  4. Double-click the group whose data you want to filter.
  5. Edit Group displays the properties of the selected group.

  6. Under Filtering and Sorting, choose Filters.
  7. Choose Add to create a filter condition.
  8. A placeholder expression appears in the first row.
  9. Specify the filter condition:
    1. Click Expression.
    2. Two buttons appear on the right. The arrow button displays a list of fields you can use in the filter expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
    3. For Expression, specify the filter expression.
    4. For Operator, select an operator from the drop-down list.
    5. For Value 1, specify the value to search. You can type the value, select from the list of values, or use Expression Builder to create a more complex value expression.
    6. If you selected the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
    7. For Value 2, specify a value only if you selected the Between or Not Between operator.
    The following illustration shows an example of a filter condition.

  10. Choose OK.
  11. Preview the report to verify the results.
  12. The report displays a different set of group values.

 


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic