Ad-Hoc Wizard: Filters & Conditions
The third step in the wizard provides the ability for granular filtering and conditions to be applied to the report.
To better understand how to use the filters/conditions functionality, lets breakdown the components. In the picture below each of the components of the filtering control are numbered.
1: And/Or Selector: Used to determine if a new expression is being added as an AND or OR condition
2: Add New Filter Expression: Adds a new filter expression to the list of conditions (takes into consideration the And/Or Selector)
3: Add Expression Group: Adds a new sub-grouping of expressions to be used in complex conditions. (takes into consideration the And/Or Selector between groups)
4: Remove Filter Item: Removes the filter/condition from the list of applied filters and conditions
Saving and Previewing
Once the filters/conditions have been specified, click Save & Preview Filter(s) to save the filters to the Ad-Hoc report and bind the results to the grid on the screen for a preview of what the results would be. If the results need to be modified they can be done so by changing the filters/conditions defined on the screen and clicking Save & Preview Filter(s) again.
An example of filtered results is shown below.