Crystal Reports - Filters

Filters are used to limit the records in a Crystal Report as per the user’s requirement. Filters are applied based on the object, operator and parameter.

How to create an Interactive Filter in a report?

Go to Data tab at the top → Interactive Filter

Click Add Filter → Select first object from filter → Select Operator → Select Parameter

In the dropdown list it will show the list of all parameters that are created for the report. To edit the parameter, you can click on ellipsis button in the end.

When a parameter is selected, click on OK. If you have selected list of values in parameter, it will ask you to select a value from the dropdown list → Select value → OK

Choose saved data or refresh data → Report now shows only filter data.

To add multiple interactive filters, you can use ‘AND’ and ‘OR’ operators.

To delete an interactive filter

Go to Data tab →Interactive filter → Select filter you want to delete → Click on delete button