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
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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.