- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
FIXING PAGE TITLES DURING SCROLLING IN SSRS 2008 R2
Part one of a two-part series of blogs
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 article)
- Fixing Top Rows when you Scroll a Report
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!
FIXING PAGE TITLES DURING SCROLLING IN SSRS 2008 R2
Part one of a two-part series of blogs
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 article)
- Fixing Top Rows when you Scroll a Report
Comments on this blog
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 ...