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 parameters applicable to the report, as well as the other options available.
Parameters
The Parameters section may or may not be shown in this screen. What is shown will be determined by what parameters have been defined when the report was created.
Filters
A user can enter up to ten filters. These will be applied in addition to the parameters defined above. 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 operator is very useful and allows for additional functionality.
| Type | Example Value | Description |
|---|---|---|
| Multiple value or list | 1000,2000,3000 | Specify multiple values separated by a comma to include a multiple values as a list. |
| Return all values | *, null | To dynamically use a single parameter to return filtered results or all values on request, you can specify “*, null” as the value. This will return all rows where the criteria is either null or contains a value. |
| Wildcard list | *test,*train,*temp | Specify a list with wildcards to return all values that meet each criteria e.g. the example value will return all rows where the value ends with either test, train or temp. |
| List with an exclude | *test*,*train*,~work train,*temp* | Specify a list with (or without) wildcards, and exclude values that don’t need to be returned e.g. all test, train and temp values will be returned except for the value work train. |
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.