Operators
Using operators is one way you can create a customized filter. Similar to operators in mathematics or programming languages, the operators dictate an action or procedure taken by the Report Designer.
Figure: Filter operators in Report Designer
In the first drop-down box, these two options are available:
Option | Function |
blank | Will include all data inside the specified filter. |
Not | Will include all data outside the specified filter. |
If there are multiple filters in the same group, these options will also be available in the first drop-down box:
Option | Function |
And | Will filter the first condition AND the second condition. |
Or | Will filter the first condition OR the second condition. |
And Not | Will filter the first condition AND NOT the second condition. |
Or Not | Will filter the first condition OR NOT the second condition. |
In the second drop-down box, these filter operators are available:
Option | Function |
In | dimension is In… (the selected parameters) |
<> | dimension is Not equal to… (the selected parameters) |
< | dimension is Less than… (for numerical values) |
> | dimension is Greater than… (for numerical values) |
<= | dimension is Less than or equal to… (for numerical values) |
>= | dimension is Greater than or equal to… (for numerical values) |
Begins with | dimension Begins with… (for any phrase contained in the dimension) |
Ends with | dimension Ends with… (for any phrase contained in the dimension) |
Contains | dimension Contains… (any part of the phrase contained in the dimension) |
Like | OSR Report Designer will retrieve any data using “LIKE …” in SQL.* |
*The Like operator is for advanced users and requires knowledge of SQL.