Export (0) Print
Expand All
Expand Minimize

How to: Display Headers and Footers with a Group (Report Builder 2.0)

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.

If you want 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 How to: Display Row and Column Headers on Multiple Pages (Report Builder 2.0).

To control the rendering behavior for dynamic rows and columns associated with nested groups, or for static rows and columns 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 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 Understanding Tablix Data Region Cells, Rows, and Columns (Report Builder 2.0).

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 group headers and footers display on the same page as the group; use KeepTogether to help display static members with the rows or columns of a group; and 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.

NoteNote

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

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. For example, used for group footer rows.

    • After   Select this option to keep this member with the members of the following group. For example, used 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. For example, used 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. For example, used 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft