Grouping Pane

  • Article
  • 4 minutes to read

When designing Reporting Services reports, the Grouping pane displays the row groups and column groups for the currently selected Tablix data region. The Grouping pane is not available for the Chart or Guess data regions. The Group pane consists of a Row Groups pane and a Cavalcade Groups pane. The Grouping pane has two modes: default and Advanced. Default mode displays a hierarchical view of the dynamic members for row and column groups. Advanced way displays both dynamic and static members for row and cavalcade groups. A group is a named set of data from a report dataset that is displayed on a data region. Groups are organized into hierarchies that include static and dynamic members. For more information, run into Understanding Groups (Study Builder and SSRS).

ssrs_fyi_note If yous practise not see the Grouping pane, on the Report menu, click Grouping.

Cells in the row and column group areas can exist static or dynamic members of a grouping. Static members echo in one case per group and typically incorporate labels or totals. Dynamic members repeat one time per group instance and typically contain the unique values of the grouping expression. As you select Tablix cells in the row group surface area or column group area, the respective grouping member is selected in the Row Groups or Column Groups pane. Conversely, if you select groups in the Grouping pane, the corresponding cell associated with the group fellow member is selected on the design surface. For more than information about Tablix row and column group areas, see Tablix Information Region Areas (Study Builder and SSRS).

The Grouping pane supports the following modes:

  • Default. Use the default mode to add, edit, or delete groups. Y'all can add parent, child, and item groups by dragging fields from the Report Data pane and inserting them in the grouping bureaucracy. To add an adjacent group, you lot must use the Add Grouping shortcut. For more information, see Add or Delete a Group in a Data Region (Report Architect and SSRS).

  • Advanced. Use the Avant-garde mode to view all members of row and cavalcade groups, and to set properties on static members. When you lot create groups or add totals, the properties that control how the Tablix information region renders rows and columns on each written report folio are set automatically. To manually accommodate these properties, you must set them on the Tablix fellow member. For more data, meet Decision-making the Tablix Data Region Brandish on a Written report Page (Report Architect and SSRS).

Default Fashion

In default manner, the Row Groups pane and the Column Groups pane display a hierarchical view for all parent groups, child groups, and adjacent groups. A child group appears indented under its parent group. An adjacent group appears at the aforementioned indent level every bit its sibling groups. The following figure shows a Tablix data region with nested row groups and nested and next column groups.

Tablix, nested and adjacent row and column groups

The Grouping pane displays the corresponding row and column groups. In the following figure, the grouping based on subcategory has been selected in the Row Groups pane, and the [Subcat] grouping cell is selected in the Tablix information region:

Grouping pane for nested row and column groups

In the Row Groups pane, the group based on subcategory is a kid of the grouping based on category. In the Column Groups pane, the land/region grouping is a child of the geography group. The year group and the state/region groups are next groups.

For more information, see Tablix Data Region Cells, Rows, and Columns (Report Builder) and SSRS.

Avant-garde Manner

In Advanced way, you tin view all static and dynamic members of a group. When you lot select a member, the Properties window displays properties for the currently selected Tablix member.

ssrs_fyi_note To toggle Advanced mode, right-click the down arrow at the side of the Column Groups pane, and so click Advanced Mode.

In nigh cases, properties that control the brandish of static and dynamic group rows and group columns are set automatically when you create a grouping or add totals.

To edit the default values, you must select the grouping fellow member in the Row or Column Groups pane, and change the property values in the Properties window. If the properties pane is not visible, in the View menu, click Properties or press F4. The post-obit properties are available:

  • FixedData. Boolean. For outer row and cavalcade headers. Freeze the row group area when scrolling vertically or the column group area when scrolling horizontally in a renderer such as HTML.

  • HideIfNoRows. Boolean. For static members only. If set, Subconscious and ToggleItem are ignored. Hibernate this member if the Tablix data region contains no rows of data.

  • KeepTogether.

  • KeepWithGroup. Boolean. For static row members merely. Where possible, keep this row with the previous or following sibling dynamic member, if it is not hidden.

  • RepeatOnNewPage. Boolean. For static row members only and where KeepWithGroup is not None. Where possible, repeat this static row on every page that has at least 1 case of the dynamic fellow member specified by KeepWithGroup.

  • Hidden. Boolean. Indicates whether the row or column should be initially hidden.

  • ToggleItem. String. The proper noun of the text box to which to add together the toggle image. The text box must exist in the aforementioned group telescopic or a containing telescopic.

For more information virtually how this behavior can exist controlled on a Tablix data region, run across Controlling the Tablix Data Region Brandish on a Written report Page (Report Builder and SSRS).

Not every static fellow member has a header that corresponds to a cell on the design surface. In the Grouping pane, the following convention indicates whether a static member has no header:

  • Static Indicates a static member with a header prison cell.

  • (Static) Indicates a static member with no header prison cell, known as a hidden static.

Meet Also

Tables, Matrices, and Lists (Report Builder and SSRS)
Expressions (Report Builder and SSRS)
Filter, Group, and Sort Data (Written report Builder and SSRS)