Export (0) Print
Expand All
Expand Minimize
7 out of 27 rated this helpful - Rate this topic

How to: Display Row and Column Headers on Multiple Pages (Reporting Services)

SQL Server 2008

For a table or matrix data region that spans multiple pages, you can control whether to repeat the initial rows that contain column headings or the initial columns that contain row headings. How you control repeating headers depends on the type of row or column that you want to repeat.

To repeat the first row or rows that contain column headings:

  • For a matrix with column groups, the rows that display column names are controlled by the column group. Set tablix properties for Column Headers.

  • For a table, the row that contains column names is controlled by the tablix member in a row group. Set tablix member properties in the Properties pane.

To repeat the first column or columns that contain row headings:

  • For a matrix with row groups, the columns that display row names are controlled by the row group. Set tablix properties for Row Headers.

  • Controlling the first columns in a table without column groups is not supported. To control these columns, add a column group to the table.

Only the first row and adjacent rows or the first column and adjacent columns can repeat on each page. Headings are repeated on each page only if there is sufficient room.

For more information, see Controlling Row and Column Headings.

To repeat rows with column headings in a column group area

  1. In Design view, right-click the corner handle for a selected tablix data region, and then click Tablix Properties.

  2. On the General tab, under Column Headers, select Repeat header columns on each page.

  3. Click OK. 

  4. Preview the report. The rows that contain the column headings repeat at the start of each page.

To repeat rows with column headings for a table with row groups

  1. In Design view, select the table. The Grouping pane displays the row groups.

  2. On right side of the Grouping pane, click the down arrow, and then click Advanced. The Grouping pane displays static and dynamic tablix members for each group. You can only set properties on a static tablix member.

  3. In the Row Groups pane, click the static tablix member for the row that you want to repeat. When you select a static tablix member, the corresponding cell on the design surface is selected, if there is one. The Properties pane displays the properties for the selected tablix member.

  4. Set the KeepWithGroup property in the following way:

    • For a static row that is above a group, click After.

    • For a static row that is below a group, click Before.

  5. Set the RepeatOnNewPage property to True.

  6. Preview the report. If possible, the row repeats with the group on each vertical page that the row group spans.

To repeat columns with row headers in a row group area

  1. In Design view, right-click the corner handle for a selected tablix data region, and then click Tablix Properties.

  2. On the General tab, under Row Headers, select Repeat header rows on each page.

  3. Click OK.

  4. Preview the report. If possible, the columns that contain the row headers repeat on each horizontal page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.