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:
|6||Value that matches the data type of the field|
|7||Functions for editing rows|
Inserting, deleting and sorting table rows
Select a row and use one of the following buttons:
Button Description Append Adds a new row.
Alternatively, you can click into the next row.
Insert Inserts a new row above the selected row. Delete Deletes the selected row. ↑, ↓ Changes the order of the rows / filter expressions.
Alternatively, use a drag-and-drop operation.