4.6.3 Adding a Filter

Create row and column filters on an interactive report.

• About Creating Filters
  You can create a filter on an interactive report by using the Actions menu to create or modify a column filter or row filter.
• Adding, Editing, and Removing a Column Filter
  Use the Actions menu to add, edit, or remove a column filter in an interactive report.
• Adding, Editing, and Removing a Row Filter
  Use the Actions menu to add, edit, or remove a row filter in an interactive report.

4.6.3.1 About Creating Filters

You can create a filter on an interactive report by using the Actions menu to create or modify a column filter or row filter.

You can create two types of filters on an interactive report to search or narrow down the report data:

1. Column - Creates a simple filter based on a column.
2. Row - Creates a complex filter that allows multiple filter conditions, including column alias names and any Oracle functions, operators, or expressions.
   • For example, a Row filter could contain an OR operator, or an AND operator.

4.6.3.2 Adding, Editing, and Removing a Column Filter

Use the Actions menu to add, edit, or remove a column filter in an interactive report.

To add a column filter:

1. Click the Actions menu and select Filter.
   The Filter dialog appears.
2. For Filter Type, select Column.
   
   

   
   Description of the illustration add_col_filter.png

   
   
3. In the Filter region, specify a column, an operator, and an expression and click Apply.

   Notice the filter that displays in the Report Settings area above the report. You can show or hide the filter details by clicking the arrow to the left of the filter name.

To revise the filter:

4. Click the filter name (in this example, Project = 'Discussion Forum').
5. Edit your selections and click Apply.
6. To disable the filter, select the Enable/Disable Filter check box.
7. To delete the filter, click Remove Filter.

4.6.3.3 Adding, Editing, and Removing a Row Filter

Use the Actions menu to add, edit, or remove a row filter in an interactive report.

To add a row filter:

1. Click the Actions menu and select Filter.
   The Filter dialog appears.
2. For Filter Type, select Row.
3. In the Filter dialog:
   1. Name - Enter a name that describes this filter.
   2. Filter Expression - Enter an expression. Select a column and function or operator at the bottom of the region. For example, I >=2500 displays projects costing more than $2,500.
   3. Click Apply.
      Notice the filter that displays in the Report Settings area above the report. You can show or hide the filter details by clicking the arrow to the left of the filter name.
4. To revise the filter:
   1. Click the filter name.
   2. Edit your selections and click Apply.
5. To disable the filter, select the Enable/Disable Filter check box.
6. To delete the filter, click Remove Filter.