Folder - Filter

Filter folder allows you to define criteria for the report, restricting information to be printed.

Procedures

To define filters for report:

1. In the report window, click the Filter folder.

The system displays the configuration possibilities of data filter for report printing.

2. Based on the drop-down lists Fields, Operators and Expression, you can build the filter to restrict the information to be queried.

Example:

To display only the records of Bank “383”, the following operation must be defined:

Field

Operator

Operand

Bank

Equal to

383.

 

3. After the operation's elements are selected, click Add.

The selected elements are displayed in the Filter area.

4. To enter one or more operations, use the options to form logical operations:

 

Options

Description

6026a49f-c7ac-49dc-b9fc-6b5f0dfd8f726b90973d-0e6a-4dd5-8eaf-4ea00a693e1f

used to group operations, establishing the order of execution.

d32825fb-a2c6-42ee-98f2-441811e24ee7

The System allows entering of more than one expression for building the filter. When the AND operator is used, only those records that meet the two or more specified conditions are displayed.

78dc663f-c15b-4cf1-b17f-3d06772d129d

The System allows entering of more than one expression for building the filter. When the OR operator is used, the records that meet any of the specified conditions are displayed.

Examples:

Suppliers from the State of “SP” whose Type is “J”.

(State equal to SP) (Type equal to J)

This way, the System assembles the expression in the Expression area. If there are errors in building the expression, click Clear Filter.

5. Click Expression if you want to define the condition for the query using AdvPl.

Example: SUBSTR(A1_COD,3.3)=“001”

6. The System displays the screen for entering the expression.
7. When concluded, click Add to move the expression to the Filter, or Cancel to return to the filter generation screen.
8. Click Ok to start printing or click another folder to proceed the report configuration.