When you run a report, you often do not want every available record displayed or printed. Selecting a subset of records to work with is called filtering. The Filter page of the Reports Explorer and the report wizards allows you to specify which records are included in the report.

This page may not be available for some reports.

This page has the following options:

  • Use same filter next time report is run: if this option is turned on, any filter specified is used as the default filter the next time the report is selected. Of course, the filter can be changed the next time, but this option is handy if you usually use the same filter each time the report is run.

  • Filter: click this button to display the Filter dialog. This dialog allows you to determine which records to include in the report. The space below the Filter button shows the filter specified for this report.

  • Warning if no filter when report is run: if you run a report without creating a filter for it and there are a lot of records in the tables in that report, it can take a long time to run the report. To prevent this, Stonefield Query warns you that there is no filter for the report and gives you the option of running the report anyway or canceling. If you don't want to see this warning message when you run this report without a filter, turn the Warning if no filter when report is run setting off. You can set the Default warning if no filter when a report is run setting as desired in the Options dialog to control this for all new reports.

  • Exclude: click this button to display the Exclude dialog. This dialog allows you to determine which records to exclude in the report. The space below the Exclude button shows the exclusion filter specified for this report.