- Crystal Reports Tutorial
- Crystal Reports - Home
- Crystal Reports - Overview
- Crystal Reports - GUI Navigation
- Crystal Reports - Options
- Crystal Reports - Page Layout
- Crystal Reports - Getting Help
- Crystal Reports - Design Environment
- Crystal Reports - Data Sources
- Crystal Reports - Queries
- Query Filters & Filter Conditions
- Crystal Reports - Time Based Filters
- Field Objects Controls & Modifications
- Crystal Reports - Sections
- Crystal Reports - Delete Sections
- Crystal Reports - Groups
- Crystal Reports - Group Options
- Crystal Reports - Templates
- Crystal Reports - Inserting Objects
- Crystal Reports - Charts
- Crystal Reports - Cross Tab Layout
- Crystal Reports - Defining Formulas
- Crystal Reports - Formula Workshop
- Creating & Modifying Formulas
- Crystal Reports - Apply Boolean Formulas
- Crystal Reports - If-Then-Else
- Crystal Reports - Applying Calculations
- Crystal Reports - Conditional Formatting
- Crystal Reports - Creating Variables
- Crystal Reports - Creating Arrays
- Crystal Reports - Parameters
- Crystal Reports - Filters
- Crystal Reports - Prompt Panels
- Crystal Reports - Cascading Prompts
- Crystal Reports - Create Parameter Field
- Crystal Reports - Edit Parameter Field
- Crystal Subreports - Overview
- Crystal Reports - Data Export Overview
- Crystal Reports - Data Export to Excel
- Crystal Reports - Data Export to XML
- Crystal Reports - Data Export to HTML
- Crystal Reports - Data Export to CSV
- Crystal Reports Useful Resources
- Crystal Reports - Quick Guide
- Crystal Reports - Useful Resources
- Crystal Reports - Discussion
Crystal Reports - Groups
In this chapter, we will cover how to define, render and delete groups.
Define Groups
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
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.
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 −
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.
