Add or Remove Filters

Home > Report Manager > Working with Reports > Editing Reports > Report Filters > Add or Remove Filters

Add or Remove Filters

Adding or removing Filters enables the user to refine or limit the rows of data that will be displayed in the report. To add or remove Filters from your report, select the report where you want to add or remove Filters and then click on the Filters Tab.

The existing Filters that you have selected will be displayed.

Add Filters:

1. In the Properties Window, click the Add button and the Choose Filter Field dialog box will appear.

   

2. Select the Filter Field you would like to add to your report and click OK.

3. The Choose Comparison Method dialog box will appear.

   

4. Choose your comparison method and click OK.

   The Enter Comparison Value window will appear.

   

5. You may now either:

   • Enter your Comparison Value in the field provided, or

   • Use the lookup button to view a selection Comparison Values, and click OK.

6. Note: The Lookup facility will only be available if it has been enabled in the Connector for this expression. See Add Data Expressions.

7. Use the Select System Variable button to view a list of System Variables, and click OK.

   Note: For further information about System Variables see System Variables.

8. The new Filter should now appear on the Filters Tab.

To remove Filters, in the Properties Window, select the Filters that you would like to delete and click the Remove button.