display-row-and-column-headers-on-multiple-pages-report-builder-and-ssrs.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Show row and column headers on multiple pages in a report	Learn how to control repeating row and column headers on every page of a paginated report for a tablix data region that spans multiple pages in Report Builder.	kfollis	kfollis	09/25/2024	reporting-services	report-design	how-to	updatefrequency5

Show row and column headers on multiple pages in a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

You can control whether to repeat row and column headers on every page of a paginated report for a tablix data region (a table, matrix, or list) that spans multiple pages.

How you control the rows and columns depends on whether the tablix data region has group headers. When you select a tablix data region that has group headers, a dotted line shows the tablix areas, as shown in the following figure:

:::image type="content" source="../../reporting-services/report-design/media/rs-tablix-areas.png" alt-text="Screenshot of a tablix data region that highlights the different areas and groups.":::

Row and column group headers are created automatically when you add groups by using the New Table or Matrix wizard, or the New Chart wizard, by adding fields to the Grouping pane, or by using context menus. If the tablix data region has only a tablix body area and no group headers, the rows and columns are tablix members.

For static members, you can display the top adjacent rows or the side adjacent columns on multiple pages.

Display row headers on multiple pages

1. Right-click the row, column, or corner handle of a tablix data region, and then select Tablix Properties.

2. In Row Headers, select Repeat header rows on each page.

3. Select OK.

Display column headers on multiple pages

1. Right-click the row, column, or corner handle of a tablix data region, and then select Tablix Properties.

2. In Column Headers, select Repeat header columns on each page.

3. Select OK.

Display a static row or column on multiple pages

1. On the design surface, select the row or column handle of the tablix data region. The Grouping pane displays the row and column groups.

2. On the right side of the Grouping pane, select the down arrow, and then select Advanced Mode. The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy and the Column groups pane shows a similar display for the column groups hierarchy.

3. Select the static member that corresponds to the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties.

   If you don't see the Properties pane, select the View tab at the top of the Report Builder window and then select Properties.

4. In the Properties pane, set RepeatOnNewPage to True.

5. Set KeepWithGroup to After.

6. Repeat this process for as many adjacent members as you want to repeat.

7. Preview the report.

As you view each page of the report that the tablix data region spans, the static tablix members repeat on each page.

Related content

• Find, view, and manage reports (Report Builder and SSRS)
• Export paginated reports (Report Builder)
• Controlling page breaks, headings, columns, and rows in paginated reports (Report Builder)
• Display headers and footers with a group in paginated reports (Report Builder)
• Keep headers visible when scrolling through a paginated report (Report Builder)