SAP Crytal Report

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

When you need to separate the data into groups in order to make it easily understood, grouping option can be used. You can also customize grouping for a single value or multiple values by using the customize option inside the grouping tab.

To apply grouping in the report, go to structure tab of the report → Data → Groups

Data Groups

Render Groups

To add a grouping condition. Click on New ("+" sign) and select the attribute on which you want to apply grouping. If you apply regular grouping on one object, it will group all the similar values in a report.

Render Groups

To apply grouping on single value, go to customize grouping option → New → Add Condition → select operator and value from the dropdown list as shown in the following image −

Add Condition

It also gives an option to discard everything else, group everything else in single group with group name or include everything else without changing the group name.

In the following example, it has created 2 groups: first with Region Name=”New Delhi” and second group with everything else with group name “Others”.


When you use grouping in a report, two new sections appear in the report canvas − Group Header 1 and Group Footer 1.

Delete Groups

To delete a group, select the group you want to remove and click on the Delete option.

Go to Structure of the report → Groups → select groups #1, 2 you want to delete → Delete.

Delete Groups

See All

Comments (349 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 /349

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 /349

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 /349