TechNet
Export (0) Print
Expand All

Display Headers and Footers with a Group (Report Builder and SSRS)

 

Applies To: SQL Server 2016

You can help control whether a static row, such as a group header or footer, renders with dynamic rows that are associated with a group in a tablix data region.

To repeat all the column headings or row headings on multiple pages, you can set properties for the tablix data region. For more information, see Display Row and Column Headers on Multiple Pages (Report Builder and SSRS).

To control the rendering behavior for dynamic rows and columns that are associated with nested groups, or for static rows and columns that are associated with labels or subtotals, you must set properties for the tablix member. A tablix member represents a static or dynamic row or column. A static member repeats once. For example, a grand total row is a static row. A dynamic member repeats once for each group instance. For example, a row that is associated with a group that has the group expression [Territory] repeats once for each unique value for territory. For more information about tablix members, see Tablix Data Region Cells, Rows, and Columns (Report Builder) and SSRS.

You can select a tablix member in the Grouping pane and set the properties KeepWithGroup, KeepTogether, and RepeatOnNewPage in the Properties pane. Use KeepWithGroup to help display group headers and footers on the same page as the group. Use KeepTogether to help display static members with the rows or columns of a group. Use RepeatOnNewPage to repeat the group header or footer on every page that displays at least one complete instance of the row group member designated by the KeepWithGroup value. RepeatOnNewPage is not supported for column group members.

System_CAPS_ICON_note.jpg Note


KeepWithGroup, KeepTogether, and RepeatOnNewPage are group member properties that you can set by using the Advanced Mode of the Grouping pane. For more information, see Grouping Pane (Report Builder).

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

To keep a static row with a set of dynamic rows associated with a row group

  1. On the design surface, click anywhere in the tablix data region to select it. The Grouping pane displays the row and column groups for the data region.

  2. On the right side of the Grouping pane, click the down arrow, and then click Advanced Mode. The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy.

  3. Click the static member that corresponds to the row header or footer that you want to keep with the group rows. The Properties pane displays the Tablix Member properties.

  4. In the Properties pane, click KeepWithGroup, and then choose one of the following values from the drop-down list:

    • None Select this option to indicate no preference for keeping this member with the members of the selected row group.

    • Before Select this option to keep this member with the members of the previous group. You might use this for group footer rows.

    • After Select this option to keep this member with the members of the following group. You might use this for group header rows.

  5. (Optional) Preview the report. Where possible, the report renderer keeps this member with the specified row group members.

To keep a static column with a set of dynamic columns associated with a column group

  1. On the design surface, click anywhere in the tablix data region to select it. The Grouping pane displays the row and column groups for the data region.

  2. On the right side of the Grouping pane, click the down arrow, and then click Advanced Mode. The Column Groups pane displays the hierarchical static and dynamic members for the column group hierarchy.

  3. Click the static member that corresponds to the static column that you want to keep with the group columns. The Properties pane displays the Tablix Member properties.

  4. In the Properties pane, click KeepWithGroup, and then choose one of the following values from the drop-down list:

    • None Select this option to indicate no preference for keeping this member with the members of the selected column group.

    • Before Select this option to keep this member with the members of the previous group. You might use this for column labels that display before the specified column group members.

    • After Select this option to keep this member with the members of the following group. You might use this for column totals that display after the specified column group members.

  5. (Optional) Preview the report. Where possible, the report renderer keeps this member with the specified column group members.

Tablix Data Region Cells, Rows, and Columns (Report Builder) and SSRS
Tablix Data Region Areas (Report Builder and SSRS)
Tablix Data Region (Report Builder and SSRS)
Tables (Report Builder and SSRS)
Matrices (Report Builder and SSRS)
Lists (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft