Add Filters

You can select fields to filter your report's output.

To add a field as a filter:

  1. Select Add Filter on the Column Action menu or click the Filters tab and drag the desired field into the appropriate filter type (Prompted or Static).
  2. Select Matching ALL conditions (AND) or Matching ANY conditions (OR) if you want to group the results.

    The following types and options are available when you add fields as a filter:

  3. Depending on the filter Type that you select, the following options become available
    Operator/Type Options
    Select from values found in report

    Allows you to select filter criteria from a drop-down list

    • One of / Not One of: Matches a value in a list (or not)
    Choose a date from the calendar

    Allows you to enter a date or date range as the filter criteria

    • Equal to/ Not Equal to:
    • Greater than/Greater than or Equal to
    • Less than/Less than or Equal to

    matches or done not match

    Enter a date range

    Allows you to enter a date or date range as the filter criteria

    • Between / Not Between: Checks if the date is between or not between the date range you specify.
    Enter text

    Allows you to enter text/keywords as the filter criteria.

    • Equal to / Not Equal To: Will return results that are equal or not equal to the value entered for the filter.
    • Greater than/Greater than or Equal to
    • Less than/Less than or Equal to
    • Like/Not Like: Will return results that exactly match/do not match what is entered
    • One of/Note One of: Will return results that match/don't match the items in the list.
    Enter a value range

    Allows you to enter text/keywords as the filter criteria.

    • Between / Not Between: Checks if the value entered for the filter is or is not between the values you enter in the fields provided.
    Select from session values

    Allows you to select filter criteria from a drop-down list

    • Equal to / Not Equal To: Will return results that are equal or not equal to the value entered for the filter.
    • Greater than/Greater than or Equal to
    • Less than/Less than or Equal to
    • Like/Not Like: Will return results that exactly match/do not match what is entered
    • One of/Not One of: Will return results that match/don't match the items in the list.
    Select from a list of special operators

    Allows you to select filter criteria from a drop-down list

    • Equal to / Not Equal To: Will return results that are equal or not equal to the value entered for the filter.
    • Greater than/Greater than or Equal to
    • Less than/Less than or Equal to
    • Like/Not Like: Will return results that exactly match/do not match what is entered
    • One of/Not One of: Will return results that match/don't match the items in the list.
    Enter SQL

    Allows you to enter text/keywords as the filter criteria.

    • Equal to / Not Equal To: Will return results that are equal or not equal to the value entered for the filter.
    • Greater than/Greater than or Equal to
    • Less than/Less than or Equal to
    • Like/Not Like: Will return results that exactly match/do not match what is entered
    • One of/Not One of: Will return results that match/don't match the items in the list.