Export (0) Print
Expand All
3 out of 13 rated this helpful - Rate this topic

How to: Keep Headers Visible When Scrolling Through a Report (Report Builder 3.0 and SSRS)

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

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, 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 considered static tablix members. For static members, you can prevent the top adjacent rows or the side adjacent columns from scrolling out of view.

NoteNote

You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. 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 3.0 (SSRS) on the Web at microsoft.com.

To keep tablix 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 tablix member (row or column) visible while scrolling

  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 (row or column) that you want to remain visible while scrolling. The Properties pane displays the 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.