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:

Select Rows>Filter from the menu bar.

The Specify Filter dialog box displays.
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.
Click OK.

InfoMaker filters the data. Only rows meeting the filter criteria are displayed.

To remove the filter:

Select Rows>Filter from the menu bar.

The Specify Filter dialog box displays, showing the current filter.
Delete the filter expression, then click OK.

Filtered rows and updates Filtered rows are updated when you update the database.