Displaying a group horizontally

By default, groups are displayed vertically in a document. This means that the detail sections are displayed below the Group Header. For example, a document is grouped by Year. The Detail section includes revenue and profit information by region. Displaying the group vertically yields the following document:

For certain documents, displaying and printing the group horizontally is desired. When displayed horizontally, the detail sections are displayed next to the Group Header, running horizontally across the page.

The example given above, if displayed horizontally, shows a row containing the year, and then, for each region, the Region, Revenue, and Profit. When the document is viewed as a PDF, it displays as shown below:

When being designed, the document with horizontal display looks like the following in MicroStrategy Developer:

The sections within the group are turned sideways and listed horizontally, across the page. These horizontally rendered sections are the Group Header and Footer (in this case, Year), the Detail Header, the Detail, and the Detail Footer. They are displayed in the same order as when shown vertically. The Page and Document sections are still listed vertically.

You can also change the orientation of only the lower level detail sections. In the following sample, the Detail Header, Detail, and Detail Footer are displayed horizontally while the Group Header and Group Footer are displayed vertically:

You can also display the Detail Header and Detail Footer vertically while keeping the Detail section horizontal. A document does not have to be grouped to allow these sections to be displayed horizontally. For information on displaying sections horizontally without groups, see Displaying sections horizontally.

Horizontally displayed sections have additional options to control the horizontal width. For more information, see Changing the horizontal width of a section.

Prerequisite

This procedure assumes that the document is already grouped.

To display a group horizontally

In MicroStrategy Web, open the document in Design or Editable Mode.
From the Tools menu, select Grouping. The Grouping panel is displayed.
In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. The Grouping Properties dialog box opens.
Select the Render object name horizontally check box.
Click OK to apply the changes and return to the document.

Adding more grouping fields to horizontally displayed groups

When you add another grouping field, its location in the Grouping panel controls whether it is displayed and printed horizontally or vertically, as described below:

All groups to the right of a horizontally displayed group display horizontally. Therefore, if you add the field to the right of a horizontally repeating group, the new group is displayed horizontally.
If you add the field to the left of all horizontally displayed groups, the new group is displayed vertically.

For example, continuing with the previous example, add Region to the right of Year in the Grouping panel. The Region Header and Region Footer sections are displayed horizontally, as shown below. (The Region text field has been moved from the Detail section to the Region Header section, to help differentiate the sections.)

If you add Region to the left of Year instead, the Region Header and Region Footer are displayed vertically, as shown below:

If you then add Category between Region and Year in the Grouping panel, Category is displayed vertically. This occurs because Category is to the left of the horizontally displayed group.

Changing the grouping order of horizontally displayed groups

If you move a group on the Grouping panel, thereby changing the grouping order, only the moved group changes its orientation. This means that, if you move a horizontally displayed group, that group can become vertically displayed, if necessary, but the orientation of no other groups change. If you move a vertically displayed group, that group can become horizontally displayed, if necessary, but no other orientation changes.

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.

If you move a horizontally displayed group, its orientation depends on the orientation of the groups to its right. The following rules determine whether it remains horizontal or changes to vertical:

If you move a horizontally displayed group to the left,
- And if all groups to the right are horizontal,
  
  Then the moved group remains horizontal
- And if at least one group to the right is vertical,
  
  Then the moved group is rendered vertically
If you move a horizontally displayed group to the right,
- All groups to the right must be horizontal by definition,
  
  So the moved group remains horizontal

If you move a vertically displayed group, its orientation depends on the orientation of the groups to its left. The following rules determine whether it remains vertical or changes to horizontal:

If you move a vertically displayed group to the right,
- And if all groups to the left are vertical,
  
  Then the moved group remains vertical
- And if at least one group to the left is horizontal,
  
  Then the moved group is displayed horizontally
If you move a vertically displayed group to the left,
- All groups to the left must be vertical by definition,
  
  So the moved group is displayed vertically

For example, a document is grouped by Year, Region, and Category, left to right. Year is displayed vertically; Region and Category are displayed horizontally, as depicted in the following table:

Year	Region	Category
Year
	Region	Category

You move Category all the way to the left, past Year. Category becomes vertical, because a group to the right (Year) is vertical. The result is shown below.

Category	Year	Region
Category
Year
	Region

You move Year to the right, after Region. Year becomes horizontal, because all groups to the right of a horizontal group must be horizontal.

Category	Region	Year
Category
	Region	Year

You move Region to the left, before Category. Region becomes vertical, because a group to the right (Category) is vertical.

Region	Category	Year
Region
Category
	Year

For steps to change the grouping order, see Changing the grouping order in a document.