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. 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.
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. |
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. |
Responsibility | Select a responsibility for this report. Only responsibilities selected at logon, or that have access via a request group (in Oracle) to the report definition, will be available in the list of values. |
Once all the parameters are as required, click OK to run the report.
The Clear Filters button will clear all the filters.