Users can refine the data set returned within a report by using the Filter tools within the Edit View. Below are the types of filters:
Applied to a single report tab. They are similar to Query Filters but that you cannot prompt on them.
A flexible way to allow end Users to filter reports. Unlike Simple Filters, the look, feel, and operation of these filters can be customized. Input Controls can be applied to individual report pages or the whole document.
Creating Report Filters
Step 1 – Click the table that needs the filter
Step 2 – Click into the Report Element Data panel
Step 3 – Select the Filter icon
Step 4 – Drag an object or variable from the available objects into the drop box
Step 5 – To define the filter, click the desired value, or the gear icon for the settings
If Settings is chosen, choose the preferred Operator and any other requirements. Once set, hit the back button in the top left corner.
Step 7 – Click OK.
Step 8 - To remove a filter select the X icon in the filter box
Filters can also be access by right clicking in the column that needs the filter, and selecting Data > Add Filter