MicroStrategy ONE

Grouping Properties dialog box

The Grouping Properties dialog box allows you to set properties for an individual group. These properties affect the PDF View only; they do not change the display in Design View. Page-by also affects the HTML View.

Accessing the Grouping Properties dialog box

Right-click a field in the Grouping panel and select Grouping Properties.

Grouping Properties layout

The dialog box contains the following options:

  • Page-By mode: Sets whether to page by the selected group. Page-by allows you to interactively display groups on separate pages in PDF and HTML View. The modes are:

  • No Page-By (All Only): Disables page-by, so that you cannot page by the elements of this group. The PDF contains all elements of this group. This mode is useful for the groups on the right in the Grouping panel, where it may not be useful to show one element at a time.

  • Page-By (Single Element Only): Enables page-by for this group, but you cannot select to display all the elements of the group simultaneously in PDF or HTML View. This is useful for groups with many elements, when you would not want to display all the elements simultaneously.

    When a document contains multiple groups, this option is unavailable for the group farthest to the right in the Grouping panel.

  • Page-By (Single Element or All): Enables page-by for this group and allows all elements of the group to be displayed simultaneously. By default, this mode is selected.

    If you disable page-by for a particular grouping field, all fields to the right of it in the Grouping panel are also disabled. You cannot change the Page-By mode of a grouping field if the one to the left of it in the Grouping panel is set to No Page-By.

  • Show option for Total: Adds a group-by option for Total, so that you can select it in PDF View. For more information, see Showing totals for a group.

  • Show header: Determines if the header section for this group is displayed.

  • Show footer: Determines if the footer section for this group is displayed.

  • Render group horizontally: Determines if the group is displayed horizontally, with the detail sections displayed next to the group header, horizontally across the page. For an example and more information, see Rendering a group horizontally.

  • Render lower level sections horizontally: Determines if the lower level sections (that is, the detail sections) are displayed horizontally. The Detail Header, Detail, and Detail Footer are displayed horizontally while the Group Header and Group Footer are displayed vertically. This check box is selected and unavailable when the Render group horizontallycheck box is selected.

PDF properties

  •  

  • Keep group together: When selected, page breaks are not allowed within the selected group, from its Group Header to its Group Footer and all the content between them. By default, page breaks are allowed. Applies to PDF only.

  • Page break between groups: When selected, each group begins on a new page. By default, groups are printed on the same page. Applies to PDF only.

  • Restart page numbering: When selected, page numbering restarts for each group. By default, page numbering does not restart. Applies to PDF only.

    Restart page numbering is available only when Page break between groups is selected.

Excel property

Related Topics