Previous TopicNext Topic


How to filter at the report element level

These instructions assume you already created a report that uses a table to display data from a data set.

  1. Open Property Editor.
  2. In the layout editor, select the table or list whose data you want to filter.
  3. Property Editor displays the properties of the table or list.

  4. Choose the Filters tab.
  5. Property Editor displays the filters page.
  6. Choose Add to create a filter condition.
  7. A placeholder filter condition appears.

  8. Specify the filter condition:
    1. Click in the cell that displays 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 a 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 some examples of filter conditions.

  9. Preview the report to verify the results.
  10. If you specified multiple filter conditions, the report displays only rows that match all filter conditions. To display rows that match one filter condition, create a single filter condition that contains an OR expression, then select the Is True operator.

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic