Specifications

Filtering rows
298 InfoMaker
Using filters
In the Report painter, you can define filters to limit the rows that display at
runtime. Filters can use most InfoMaker expression functions.
Filters do not affect which rows are retrieved
A filter operates against the retrieved data. It does not re-execute the SELECT
statement.
Defining a filter
❖ To define a filter:
1 In the Report painter, select Rows>Filter from the menu bar.
The Specify Filter dialog box displays:
2 In the Specify Filter dialog box, enter a boolean expression that InfoMaker
will test against each retrieved row.
If the expression evaluates to
true, the row is displayed. You can specify
any valid expression in a filter. You can paste commonly used functions,
names of columns, computed fields, retrieval arguments, and operators
into the filter.
International considerations
The formatting that you enter for numbers and currency in filter
expressions display the same way in any country. Changing the regional
settings of the operating system does not modify the formatting displayed
for numbers and currency at runtime.
3 (Optional) Click Verify to make sure the expression is valid.