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

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!

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!

  1. Fixing Page Titles as you Scroll down an SSRS Report (this blog)
  2. Fixing Top Rows when you Scroll a Report
This blog has 0 threads Add post