Filter definitions

When you select a filter option for a column heading, the Filter pane appears. The following fields appear on the Filter pane:

• Filter links—Let you choose the way that you indicate your data selections.
  • Pick values from a list (default).
  • Search for values.
  • Type in values.
• Filter on—Identifies the column on which to apply the filter.
• Prompt every time the report runs checkbox—Select whether to prompt every time the report is run.
• Condition drop-down list—Includes the following options:
  • Show only the following—Select values to include in the report.
  • Do not show the following (NOT)—Select values to exclude from the report.
• Data values section—Indicates your selection values.
• Missing values drop-down list—Indicate whether to:
  • Include missing values.
  • Leave out missing values.
  • Show only missing values.
• Apply the filter to individual values in the data source checkbox—Allows you to apply the filter while retrieving the data from the database so that you retrieve only the data that you want. The alternative is to retrieve all the data from the database, then apply the filter to the retrieved data.

The following table shows which filters work with each type of reporting data.

Filter to reporting data type