Pasted Graphic
The filter dialog can be an incredibly powerful tool to get the perfect amount of data out of your database. The dialog is split into two parts: the upper part for editing and adding individual conditions and the lower area for controlling all the conditions for that report. To add a condition, first you must select a field for the condition to alter. The amount of fields shown in the "Field" dropdown is controlled by the "Show" dropdown. This dropdown has three options, which show different things:
  • All Report Table Fields: For every field in the report, it will show the entire table's worth of fields in this dropdown
  • Report Fields: It will only show the fields that are in the report itself
  • All Fields: It will show all of the fields in the database
Once you select a field, you'll have to select a operator for that field. There's several options, including equals, not equals, numerical comparators, starting/ending search, in-string search and null exclusion (shown above). Once you want to add your condition, make sure to click "add". It will then show up in the box at the bottom. The above example shows the same condition in the adding menu and the bottom area. The two buttons to the left of the condition at the bottom are for Dynamic Filtering, read that section for more info about Dynamic Filtering.

The grouping buttons are where the "Logic" buttons come into play listed above. The two options can come into play within a group of two conditions or more. Simply select two or more conditions using shift to group them together. You can also do the same to ungroup, or use the "Clear All Groupings" button without selecting any items at all.