Parameter List
To edit the parameters of a Reports Wand report, click the Edit Parameters 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. Reports Wand currently does not support bind variable parameters.
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.
Filter values will show a list of values after three (3) characters have been entered.
The Advanced operator allows for additional functionality.
| Type | Example Value | Description |
|---|---|---|
| Multiple value or list | 1000,2000,3000 | Specify multiple values separated by a comma to implement an IN statement. e.g. IN (1000,2000,3000) |
| 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. |
Advanced Criteria
The Advanced Criteria section has four options.
| Option | Description |
|---|---|
| Advanced | This allows the Filters created above to 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 in the SQL.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 SQL will be “Creation Date Greater Than 01-Jan-2000 AND Create 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, and the rest of the field must be valid SQL syntax. Currently we only support AND, OR and brackets.Using the example above, if we enter 1 OR 2 in the advanced field, the SQL will become “Creation Date Greater Than 01-Jan-2000 OR Create 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. Specify either ascending or descending order. |
Once all the parameters are as required, click OK to run the report.
The Clear Filters button will clear all the filters.