Keep Headers Visible When Scrolling Through a Report (Report Builder and SSRS)

  • Article

To prevent row and column labels from scrolling out of view after rendering a report, you can keep the row or column headings visible.

How you control the rows and columns depends on whether you have a table or a matrix. If you have a table, you configure static members (row and column headings) to remain visible. If you have a matrix, you configure row and column group headers to remain visible.

If you export the report to Excel, the header will not be frozen automatically. You can freeze the pane in Excel. For more information see the Page Headers and Footers section of Exporting to Microsoft Excel (Report Builder and SSRS).

Note

Even if a table has row and column groups, you cannot keep those group headers visible while scrolling

The following image shows a table.

Table

The following image shows a matrix.

Matrix

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 keep matrix group headers visible while scrolling

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

  2. On the General tab, under Row Headers or Column Headers, select Header should remain visible while scrolling.

  3. Click OK.

To keep a static member (row or column) visible while scrolling

  1. On the design surface, click anywhere in the table to display static members, as well as groups, in the grouping pane.

    Grouping pane

    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.

  2. On the right side of the Grouping pane, click the down arrow, and then click Advanced Mode.

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

    Tablix Member properties

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

  5. Repeat this for as many adjacent members as you want to keep visible while scrolling.

  6. Preview the report.

As you page down or across the report, the static tablix members remain in view.

See Also

Tasks

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

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

Concepts

Tablix Data Region (Report Builder and SSRS)

Finding, Viewing, and Managing Reports (Report Builder and SSRS )

Exporting Reports (Report Builder and SSRS)

Grouping Pane (Report Builder)