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!

  1. Fixing Page Titles as you Scroll down an SSRS Report (this blog)
  2. 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!

Page titles before scrolling down

Before you scroll down, everything is hunky dory - you can see the titles at the top of the page.

 
Titles disappearing when scrolling down

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:

Tablix properties dialog 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

Comment added on 24 September 2012 at 18:01 GMT
This was just what I needed. Much of it I had figured out from MSDN and similar sites. However the headings overwrote the data and it was a mess. What really helped was your suggestion to use a White background for the headings. That did the trick.

Regarding moving the Headings down from the top-of-page, I chose to increase the padding for the top to 10pt. That is an alternative to adding a blank row in the table.
Comment added on 08 November 2012 at 17:25 GMT
Hi,

The keep visible whilst scrolling in the Tablix Properties only works on Matrix reports, ie those when you have a Column Group and a Row Group.

I don't know if that was Microsoft's intention though :-)

Thanks

Shelts
Reply from Andy Brown

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.