How to keep the caption visible when scrolling a report (Reporting Services)

From:https://msdn.microsoft.com/zh-cn/library/bb934257.aspx

For a table or matrix data region that spans multiple pages, you can control whether the initial row that contains the column header or the initial column that contains the row header is always displayed when the report is scrolled. The way you control to always display headings is also known as frozen headings, depending on the type of row or column you want to freeze.

Freeze the first or previous lines that contain column headings:

• For matrices with column groups, rows that display column names are controlled by column groups. Sets the Tablix property for column headings.

• For tables, rows that contain column names are controlled by the Tablix members in the row group. Set the Tablix member properties in the Properties pane.

Freeze the first or previous columns that contain row headings:

• For matrices with row groups, columns that display row names are controlled by row groups. Sets the Tablix property for row headers.

• For tables without column groups, control of the first few columns 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 be frozen on each page. The title is displayed on each page only if there is enough space.

For more information about group headings and Tablix members, see Controlling Row and column headings.

Always show rows that contain column headings for column group areas

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

2. On the General tab , under row headings, select the title should remain visible when scrolling.

3. Click OK.

4. Preview the report using a renderer that supports scrolling headings, such as the HTML renderer in Report Manager. When you scroll down the report, the row that contains the column headings is always displayed.

   Note
   By default, the background of a cell is transparent. To prevent overlapping text from appearing through row headings, set the background color of the overlapping rows to a solid color, for example,White.

Columns that contain row headings for row group areas are always displayed

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

2. On the General tab , under Column headings, select the table header should remain visible when scrolling.

3. Click OK.

4. Click Preview. When you scroll the report horizontally, the column that contains the row headers is always displayed.

For tables that do not have a row group, always display rows that contain column headings

1. Select a Tablix data region in Design view. The grouping pane displays row and column groups.

2. On the right side of the Grouping pane, click the down arrow, and then click Advanced. The grouping pane displays the static and dynamic Tablix members for each group.

3. In the Row Groups pane, click the static Tablix member that you want to control. If possible, the corresponding cells on the design surface will be selected when a Tablix member is selected. Not all Tablix members have corresponding visual elements. The Properties pane displays the properties of the selected Tablix member.

4. Set the Fixeddata property to True.

5. Preview the report. When you scroll down the report, the column headings are always displayed.

How to keep the caption visible when scrolling a report (Reporting Services)