SAP Crytal Report

How to apply Filters in Crystal Reports? . The Complete SAP Crytal Report Developer Course 2023 [Videos].

Filters are used to limit the records in a Crystal Report as per the users 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

Add Filter

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.

Ellipsis Button

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.

Saved 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

Delete Filter

See All

Comments (365 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /365

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /365

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /365