- In the layout editor, select the table that contains the data you want to filter.
- In Property Editor, choose the Groups tab.
Property Editor displays the groups you defined for the table.
- Double-click the group whose data you want to filter.
Edit Group displays the properties of the selected group.
- Under Filtering and Sorting, choose Filters.
- Choose Add to create a filter condition.
A placeholder expression appears in the first row.
- Specify the filter condition:
- Click Expression.
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.
- For Expression, specify the filter expression.
- For Operator, select an operator from the drop-down list.
- 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.
If you selected the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
- 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.
- Choose OK.
- Preview the report to verify the results.
The report displays a different set of group values.