Parameter List
To edit the parameters of a Reports Wand report, click the Parameter List button on the tool bar. This will open up a screen showing the filters applicable to the report, as well as the other options available.
Filters
A user can enter up to ten filters. Filters can be applied to any field, not just those displayed on the report. There are a number of different filter operators which are self explanatory and work as expected.
The Advanced Criteria section has three options.
| Option | Description |
|---|---|
Advanced |
This allows the Filters created above to be joined together in complex ways. If two filters are entered, and this field is left blank, then the two filters will be joined together with an AND logic. For example, assume Filter 1 is “Creation Date Greater Than 01-Jan-2000”, and Filter 2 is “Creation Date Less Than 31-Dec-2000”. If the advanced value is blank, the logic will be “Creation Date Greater Than 01-Jan-2000 AND Creation Date Less Than 31-Dec-2000”. To change this criteria, enter a value in to the Advanced field with format 1 AND (2 OR 3). The numbers represent the Filter number, and the rest of the field must be valid syntax. Currently, we only support AND, OR, and brackets. Using the example above, if we enter 1 OR 2 in the advanced field, the logic applied will be “Creation Date Greater Than 01-Jan-2000 OR Creation Date Less Than 31-Dec-2000”. |
Limit |
This numeric value limits the number of rows returned. |
Order By |
This field will override the default order by clause used when the report was defined. Optionally select to sort in ascending or descending order. |
Once all the parameters are as required, click Execute to run the report, or click Save and Close to preserve the parameters and execute at a later time.
The Clear Filters button will clear all the filters. Filters can also be cleared individually by clicking on the red trashcan icon to the right of the filter.