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.

Report filter numbers

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

  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