Reordering the Groups

Sometimes you might create a report with multiple groups and then decide that groups should be rearranged. For example, a report that sorts first by state and then by product could be changed to sort by product first and then state. There are two ways to reorder the group fields. The first is to go into the Group Expert and use the arrows above the Group By list. Click on the field that you want to change and then click on the appropriate arrow to either move it up the list or down the list. The second way to reorder the group fields is by clicking on the Group Header on left side of the report and dragging it to the new position. This changes the mouse cursor to a hand and highlights the group that will be changed. This is illustrated in Figure 3-17.

Figure 3-17. Dragging the group header to a new position.