When you build a report in SSRS2008R2 and you want the top header to stay in place while you scroll down, you would normally expect the option “Keep header Visible While Scrolling” to take care of that. Nothing could be further from the truth.
In SSRS2005 this option worked fine. You tick the checkbox and scroll down while the top bar stays in place. This is useful for larger reports that take up more than one screen. In SSRS2008R2 this option no longer works, even when you tick it.
What do you have to do to get this working?
Step 1 - Turn off the option Keep header visible while scrolling (right-click on the tablix, Tablix properties)
Step 2 - Go to the groupings of the tablix by left-clicking anywhere in the tablix. Then click the “Advanced Mode” option:
The grouping pane then looks like this:
Step 3 - Left-click the top “Static” group under ROW GROUPS. Look in the properties and set “FixedData” to “TRUE”.
If you view the report now, you see that the header row stays in place as you scroll down.
Strange that Microsoft has not fixed this in a Service Pack yet.
Frequently asked questions
Why does Keep header visible while scrolling not work in SSRS 2008 R2?
In SSRS 2005 the option worked. In SSRS 2008 R2 the checkbox does nothing, even when you tick it. You have to freeze the header another way, through the groups of the tablix.
How do I keep the header visible while scrolling in SSRS 2008 R2?
Turn the option off in the Tablix properties. Turn on Advanced Mode in the groupings. Click the top Static group under Row Groups and set FixedData to TRUE.
Where is the FixedData property in SSRS?
In the properties of the top Static group under Row Groups. You only see that group after you turn on Advanced Mode in the groupings of the tablix.
How do I turn on Advanced Mode in the groupings of an SSRS tablix?
Left-click anywhere in the tablix. Open the groupings and click the Advanced Mode option. After that you see the Static groups under Row Groups.
Should Keep header visible while scrolling be on or off in SSRS 2008 R2?
Off. Turn the option off with a right-click on the tablix and Tablix properties. Then set FixedData to TRUE for the top Static row group.
Comments
Related blogs
Wrong dot and comma in SSRS
SSRS Sparkline: NOW and TREND
Create a KPI box with an image / text overlap in SSRS