Adding a filter to an ad hoc report

Filters define the selection criteria for the records you want to include in your report. They correspond to WHERE clauses in SQL statements. To create a filter you must specify the property that you want to filter on, a comparison operator such as Equal To or Like, and the value you're comparing the property to.

Note: This topic explains how to add a single filter. You can also add multiple filters.
  1. Select Resources > Ad Hoc Reporting.
  2. Create a report, or browse to the report you want to add filters to.
  3. Click Add above the Filters grid.
  4. In the Property to Filter On column, specify the business object property you want to use for the filter.
  5. Select the correct operator (such as Equal To, Greater Than, or Starts With) from the list in the Condition column.
  6. In the Value of Property field, specify the value that you want to use for the comparison.
  7. If you want to nest multiple filters, use the Grouping and Operator columns to define how the filters are related.
    In each of the Grouping columns you can enter from one to four opening or closing parentheses. In the Operator column you can add the Boolean operators AND and OR.
  8. Click Save.