Sorting, Grouping, and Totaling

Sorting means arranging data in some kind of order to help you find and evaluate it. When you sort, SAP Crystal Reports prompts you to define the field you want the sort to be based on (sort field) and the sort direction.

Sort Direction refers to the order in which the values are displayed, once sorted.

• Ascending order means smallest to largest (1 to 9, A to Z, False to True).
• Descending order means largest to smallest (9 to 1, Z to A, True to False).  

This example shows you how to sort the Employee report by the employee’s last name.

1. From the SAP Crystal Reports main menu, select Report > Sort Records. The Record Sort Order dialog box opens.
2. From the Report Fields list, double-click hrpersnl.p_lname. The field moves to the Sort Fields list.
3. Select either ascending or descending as the Sort Direction.
4. Click OK.

Grouped data is data that is divided into meaningful groups.

This example shows you how to group the Employee Original Hire Date List report by the benefit plan description.

1. From the SAP Crystal Reports main menu, select Insert/Group. The Insert Group dialog box opens.
2. From the first drop-down list, select hbeplan.desc.
3. Click OK. The report adds a Group Header #1 section and the field Group #1 Name.

Summaries enable you to calculate averages, counts, and other group values.

This example shows you how to determine the number of employees in each group.

1. Click once to highlight the p_lname field (not the column heading).
2. From the SAP Crystal Reports main menu, select Insert > Summary. The Insert Summary dialog box opens.
3. From the first drop-down list, select Count.
4. Click OK. The numeric field is inserted in the Group Footer #1 area.
5. To the left of the Summary field, insert a text object called Employee Count.

Use the Subtotal command to insert a subtotal of the currently selected numeric field into your report.

This example shows you how to add a subtotal to each groups benefit premium.

1. Click once to highlight the p_epremium field (not the column heading).
2. From the SAP Crystal Reports main menu, select Insert > Subtotal. The Insert Subtotal dialog box opens.
3. Click OK. The numeric field is inserted in the Group Footer #1 area.
4. To the left of the Subtotal field, insert a text object called Subtotal.

Use the Grand Total command to print a report grand total of the currently selected numeric field at the end of the report.

This example shows you how to add a grand total to the report.

1. Click once to highlight the p_epremium field (not the column heading).
2. From the SAP Crystal Reports main menu, select Insert > Grand Total. The Insert Grand Total dialog box opens.
3. From the first drop-down list, select Sum.
4. Click OK. The numeric field is inserted in the Report Footer area.
5. To the left of the Grand Total field, insert a text object called Grand Total.
6. From the main menu, select File > Print Preview and go to the last page of your report to see the result.