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. |