Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Display Row and Column Headers on Multiple Pages (Report Builder and SSRS)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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

Tablix data region areas

Row and column group headers are created automatically when you add groups by using the New Table or Matrix wizard or the 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.

Note Note

You can create and modify report definitions (.rdl) 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. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To display row headers on multiple pages

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

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

  3. Click OK.

To display column headers on multiple pages

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

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

  3. Click OK.

To display a static tablix member (row or column) on multiple pages

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

  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 and the Column groups pane shows a similar display for the column groups hierarchy.

  3. Click 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, click the View tab at the top of the Report Builder window and then click Properties.

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

  5. Set KeepWithGroup to After.

  6. Repeat this 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.

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

Community Additions

© 2015 Microsoft