Hi Steemians,
This post is the seventh of the series of blogs I am writing on Reports design tool Crystal Reports.
Below are the links for earlier posts in that order.
Overview of SAP Crystal Reports - Part 1
Overview of SAP Crystal Reports - Part 2
Overview of SAP Crystal Reports - Part 3
Overview of SAP Crystal Reports - Part 4
Overview of SAP Crystal Reports - Part 5
Overview of SAP Crystal Reports - Part 6
We saw about history, versions, vendors and how to create a data source for Crystal Reports along with creating a simple report using command object and creating parameters for filtering report data, sections of Crystal Reports, how to use sub reports for parent child kind of reporting in earlier posts.
In this post, I would like to post about how we use groups in Crystal Reports, what are the advantages, additional options we can create with grouping.
Grouping is a feature as the name suggests, is to group relative data under one heading. For example, let’s take our previous posts on Crystal Reports. We see that Each Department has multiple employees.
If we display the data without using a group on department, the data will be displayed in the ascending order of the first field we normally use in report, most of the time, this will be Employee ID.
So, if we use a group, we can break order of displaying by Employee ID and can display it by Employees of a particular department in the ascending order of their Employee ID.
Let’s see how we create a grouping and how it looks before grouping and after grouping.
Without Grouping
Group Creation
We can create a group either using Insert tab (by selecting Group option) or by clicking on the icon shown with an arrow as in below screenshot.
Once we click on Create Group, we get option as below, where in, we need to select the field on which grouping is required.
As we can see in the above screenshot, we are trying to create a group on Department ID field. Click OK to continue.
This is how we create a group and display in Report.
Now, let’s see what additional options we get when we add a group. The Group option enables us to display the summaries related to that group in a section called group footer. Where, we can display the sum of a number or currency field, count of records in that group, minimum or maximum etc for that group for a field.
Let’s try inserting Count of Employees for each Department and the Sum of Salary of the employees in that group.
So, the above 2 screenshots shows us how to create Count and Summary and the location at which those 2 needs to be inserted.
The final output will be as below.
Note the highlighted number and currency values for Count of Employees and Sum of Salary for each Department.
That concludes this post, did you like it? Please Share your comments.
Bye until the next post. Have nice time. :)