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 | Description |
|---|---|
| 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
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. |
Report filter dialog
Copied!
Failed!