Use this page to enter query definitions to filter data for this report. See Report Query Rules for the rules you need to know before starting to define your query
To add a query click Add New:
- Enter a query name.
- Define the filters you wish to apply to the data:
- Click Add New.
- Select the field you want to use in the query from the drop down list.
- The contents of the drop-down list will be limited by the report type, and the data source that was selected on the Options page.
- Select the field you want to use in the query. You can only specify one data field per query, so if you want to specify more than one field you will have to define more than one query.
- Select the condition from the drop down list.
- Some conditions (e.g. is blank) do not require an entry in the Value field. Any entry in the value field for these conditions will be ignored.
- Some conditions are comparison conditions and require an entry in the Value field (e.g. equals, is greater than).
- For more information about the available fields, see Query Filters.
- Enter the value if required.
- To add another filter click Add New again.
Click Next to continue, or Cancel to cancel the Define Report Wizard operation.