Solution Properties
Solution ID:
200427112449999
Last Modified Date:
Wed Mar 23 14:26:58 UTC 2022
Taxonomy Path:
Case category//How do I...//setup/create/run a report
Author:
[email protected]
Advanced Report Writer (ARW) - How do I add filters to a report?
Description

You can use the following filters to restrict particular data field information from appearing on your report.

To add a filter to a particular field, highlight the field and click Format. The Format window appears, with the Filters section on the right.

Cause
Resolution
 Available Filters
No Filter No condition is set.
Equal To Field value must equal value in value column.
Not equal To Field value must not equal value in value column.
Less Than Field value must be less than value in value column.
Greater Than Greater than the value in value column.
Less than or equal to The field value must be less than or equal to the value entered in the value column.
Greater than or equal to The field value must be greater than or equal to the value entered in the value column.
Between Field values must be between the values stated in the value column.

If you want to filter between dates, use the following format: DD-MM-YYYY, DD-MM-YYYY.
Not Between Field values must not be between the values stated in the value column.

If you want to filter between dates, use the following format: DD-MM-YYYY, DD-MM-YYYY.
In Field values must be within the range selected in the value column.
Not In Field values must not be within the range selected in value column.
Like Comparing string entries made in the value column. You can only use this filter for text fields.

To select a group, you can use % with this filter. For example, if you want to select all employees that begin with C; my entry would be LIKE C%.
Run Time Range Displays the Filter option as you are processing the report.
Example

In this example, the report will only return employees who have a PRSI code of either A1, S1, J0 or J9:

Steps to duplicate
Related Solutions