How to: Keep Headers Visible When Scrolling Through a Report (Reporting Services)

For a table or matrix data region that spans multiple pages, you can control whether to keep in view the initial rows that contain column headings or the initial columns that contain row headings as you scroll through a report. How you control keeping headers in view, also known as freezing headers, depends on the type of row or column that you want to freeze.

To freeze 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 freeze 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 freeze on each page. Headings are kept in view on each page only if there is sufficient room.

For more information about group headers and tablix members, see Controlling Row and Column Headings.

To keep in view rows with column headings for 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 Row Headers, select Header should remain visible while scrolling.

  3. Click OK.

  4. Preview the report with a renderer that supports scrolling headers, for example, the HTML renderer in Report Manager. The rows that contain the column headers stay in view while you scroll down the report.

    NoteNote

    By default, the background for a cell is transparent. To prevent overlapping text from showing through the row headers, set the background color for the overlapping rows to a solid color such as White.

To keep in view columns with row headings for 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 Column Headers, select Header should remain visible while scrolling.

  3. Click OK.

  4. Click Preview. The columns that contain the row headings stay in view while you scroll across the report.

To keep in view a row with column headings for a table with no row group

  1. In Design view, select the tablix data region. The Grouping pane displays row and column 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.

  3. In the Row Groups pane, click the static tablix member that you want to control. When you select a tablix member, the corresponding cell on the design surface is selected if possible. Not all tablix members have a corresponding visual element. The Properties pane displays the properties for the selected tablix member.

  4. Set the FixedData property to True.

  5. Preview the report. The column headings stay in view as you scroll down the report.

Show: