Report filter dialog

The report filter includes one or more filter expressions. Each filter expression has its own table row.

A filter expression is based on one of the fields that you have selected as columns in the Report layout dialog.


Legend to numbers
1 Logical operator AND | OR

Required for the second and further filter expressions

2 Optional, NOT reverses the logical value of the filter expression
3 Opening parenthesis (for closing parenthesis, see the logical operator field)
4 Field that has been added as column in the Report layout dialog
5 Comparison operator depending on field data type








LIKE compares two strings. You can use the following wildcard characters:
_ substitute for a single character
% substitute for zero or more characters

6 Value that matches the data type of the field
7 Functions for editing rows

Inserting, deleting and sorting table rows