To add any number of additional groups to a report, repeat the previous steps. Once you’ve added multiple groups to your report, you can change group order. When you add a group, SCR always adds it as the lowest level group.
Changing the Field You Grouped By
If you have a group on your report and you want to change it, you do not need to delete it and insert another. Instead, you can change everything about a group from the Change Group Options dialog box. To change a group field or options:
1. You have two options for opening the Change Group Options dialog box:
Click Report, Change Group Expert to open the Change Group dialog box.
Select the group that you want to change, and click Options. The Change Group Options dialog box opens. Or in the Design tab, right-click the Group Header or Footer section of the group you want to change. A shortcut menu opens. Click Change Group to open the Change Group Options dialog box.
2. The Change Group Options dialog box looks just like the Insert Group dialog box, except for the name. Here you can change anything about the group. Click OK when done to close the dialog box.