Filter Settings

Overview

AND/OR Logic - define the logic used between each filter condition.
Bracket Arrows - the addition of brackets around sets of filters allows for more complex logic, used in conjunction with AND/OR logic settings.
Filter Fields - the fields added to the Filters list in order to restrict the report results.
Operator Selection - select the operator to be used in the filter, specifying how values will need to match, or differ from the condition defined.
Value Selection - either define a value for the filter condition, or set it as User Prompt for the report reader to define.
Filter Logic - displays a summary of the filters.
Add Filters - allows the user to add more fields to the filters list without closing the configuration panel.

Logic

Between each filter there is an AND / OR drop down option the user can define. This allows the user to define how the combination of multiple filters should work together to return results.

To adjust the logic, simply select And or Or from the drop down list between the pair of filters. When changing the logic you may need to use sets of brackets in order to contain items. To do this, simply click on the > arrow next to the pair of fields you wish to put in brackets. To remove, click the < arrow.

Example

If you want to return all the records you have that have and Active Booking Status AND have either a Booking Method of Web Site OR Media Category of WebView the following would be defined: