As you scroll down a report, the titles at the top of the page will disappear - this blog shows how to prevent this happening. It's not as easy as you would think!
- Fixing Page Titles as you Scroll down an SSRS Report (this blog)
- Fixing Top Rows when you Scroll a Report
Posted by Andy Brown on 26 July 2011 | 2 comments
Fixing Page Titles as you Scroll down an SSRS Report
In Excel, you can freeze windows, so that as you scroll down a worksheet the titles remain visible and unchanged at the top. In SQL Server Reporting Services 2008 R2 you can do this too - it's just much harder!
Before you scroll down, everything is hunky dory - you can see the titles at the top of the page.
As you scroll down, the titles - unsurprisingly - disappear.
Avoiding the Obvious Solution
The obvious solution is to tick the Keep header visible while scrolling box:
Ticking one of the two boxes circled should solve the problem - shouldn't it?
The only problem with this solution is - it doesn't work (which makes me wonder what these tick boxes were meant to do).
If you've tried the above solution, make sure you then untick the boxes again - otherwise the rest of this solution won't work!
The Answer - in Two Parts
The answer is:
- to tell each row that it should stay visible while scrolling; and
- to make sure that each fixed row's background is white, not transparent
The rest of this blog shows you how to accomplish these two things!
This blog has 2 comments
I didn't realise that - thanks for this comment! So the tick boxes do serve a purpose after all (although I can only get it to work for row headers as you scroll across). Weirder and weirder ...
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.