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.
Advanced Criteria
The Advanced Criteria section has three options.
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.
Once all the parameters are as required, click OK to run the report.
The Clear Filters button will clear all the filters.
