The new Group, Sort, and Total pane is an enhanced merger of the Report Wizard and the old Grouping dialog box. It enables you to quickly add totals, counts, and averages to multiple groups as the wizard builds the report.
Adding or changing groups and totals after the fact is also a piece of cake using the Group, Sort, and Total pane. From Report Layout, click the formatting tab and select Group & Sort in the Grouping & Totals controls. A graphical interface (see Figure 3-9) steps you through creating groups, sorting, and adding totals.
Because you're working with real data, you can see the effects of your selections and ensure that you're getting the anticipated results. And don't forget that although it is the default location, totals are not stuck in the group footers—they can be moved.
As with other 2007 controls, the grouping options are context sensitive and will coincide with the data type.
Was this article helpful?