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 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.