MicroStrategy ONE

Changing grouping order in a document

The document is grouped first by the object (or field) at the far left of the Grouping panel, then by the next object to the right, and so on. After you set up the grouping for a document, you can change the order simply by moving the fields in the Grouping panel.

When you change the grouping order, the fields' corresponding header and footer sections in the Layout Area also change positions. For an example, see the Document Creation Help.

Moving a grouping field can also affect whether the group is displayed vertically (detail sections are printed below the group header) or horizontally (detail sections are printed next to the group header, running horizontally across the page). All groups to the right of a horizontally displayed group must be horizontal; a document cannot contain a horizontally displayed group followed by a vertically displayed group. For the rules that govern this behavior, see Changing the grouping order of horizontally displayed groups.

Prerequisite

You can change the order only when the document is grouped by more than one field.

To change the grouping order

  1. Open the document in the Document Editor. (How?)

  2. If the Grouping panel is not displayed, select Grouping from the View menu. The Grouping panel, labeled Drop Grouping Fields Here, opens above the Layout area.

  3. In the Grouping panel, do one of the following:

    • Right-click the grouping field to move. Select MoveRight or Move Left.

    • Drag the grouping field right or left. A placeholder indicates where it will be placed. Drop it in its new location.