# 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 on—Identifies the column on which to apply the filter.
- 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.
- Prompt every time the report runs checkbox—Select whether to prompt every time the report is run.
- Filter links—Let you choose the way that you indicate your data selections.
  - Pick values from a list.
  - Search for values.
  - Type in values.
- Data values section—Indicates your selection 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.
- Missing values drop-down list—Indicate whether to:
  - Include missing values.
  - Leave out missing values.
  - Show only missing values.

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

Filter to reporting data type

Feature | Aggregate | Non-Aggregate | Date
--- | --- | --- | ---
Filter on | X | X | X
Condition | X | X | X
Prompt every time the report runs | X | X | X
Links |  | X |
Data values | X | X | X
Apply the filter to individual values... |  | X | X
Missing values | X | X | X

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.