Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
|
...
The use of pre-defined filters is especially useful in instances where:
- A common set of filters are used by report writers – such as location, or business unit; or
- If there are particularly complex filters that can be built ahead of time and are commonly used.
Create New Filter
Styleclass | ||
---|---|---|
|
...
- Filters can only be created using the formula builder. Like a standard calculated field select the filter options from the unattached fields list. Drag the filter option into the report folder list.
- On dragging the field into your folder you will be presented with the filter formula builder.
- Select the field you wish to filter and then use the operator, brackets, and or function buttons and text field to build your filter.
- Click OK to save your filter and include it into your field list. The filter will be highlighted with a filter icon.
...
Operator | Description |
---|---|
Equal to | Equal to a single alphanumeric or string value |
Greater than | Greater than a single alphanumeric or string value |
Greater than or equal to | Greater than or equal to a single alphanumeric or string value |
Less than | Less than a single alphanumeric or string value |
Less than or equal to | Less than or equal to a single alphanumeric or string value |
Different from | Not equal to or different from a single alphanumeric or string value |
Between | Between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
Not Between | Not between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
In List | One or more alphanumeric or string values |
Not In List | Two or more alphanumeric or string values |
Is Null | Record contains no value for selected attribute. No Parameter can be set |
Is Not Null | Record contains a value for selected attribute. No Parameter can be set |
Like | Records that contain the same letter or letters. |
Starts With | String starts with letter or letters |
Ends With | String end with letter or letters |
horizontalrule |
---|
Styleclass | ||
---|---|---|
|
...
...