Specifications

Manipulating data
112 InfoMaker
Filtering rows
You can limit which rows are displayed by defining a filter.
The filters you define are for testing only and are not saved with the table or
passed to the Report painter.
❖ To filter the rows:
1 Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays.
2 Enter a boolean expression that InfoMaker will test against each row:
If the expression evaluates to
TRUE, the row is displayed. You can paste
functions, columns, and operators in the expression.
3 Click OK.
InfoMaker filters the data. Only rows meeting the filter criteria are
displayed.
❖ To remove the filter:
1 Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays, showing the current filter.
2 Delete the filter expression, then click OK.
Filtered rows and updates
Filtered rows are updated when you update the database.