Add Filters
You can select fields to filter your report's output.
To add a field as a filter:
- 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).
-
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:
-
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.