Repeating Page Headers in Reporting Services 2008 R2
Part one of a two-part series of blogs

Getting rows of a table to repeat at the top of each page of a report in SSRS 2008 R2 is anything but straightforward. This blog shows the red herring to avoid and a way to solve this thorny problem.

  1. How to repeat header rows / page titles in SSRS (this blog)
  2. Using the Group Pane to Repeat Page Titles

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.

How to repeat header rows / page titles in SSRS

This is one of those blogs which shouldn't need writing.  The problem is simple:

Report with headers

Given a simple table report like this one, we want to repeat the headers at the top of each page.

 

Unfortunately, by default this is what you get if you go to anything but the first page:

Second page of report without titles

The titles only appear by default on the first page.

 

The answer should be simple:

Tick box to repeat headers

You should just be able to view the table's properties and tick one of the boxes shown.

 

Unfortunately, these tick boxes seem to have no effect - and the truth seems to be much murkier.

I use the word "seems" above because - although I'm pretty certain I'm right about this - I just can't believe the solution is so difficult!

So how do you get page titles to repeat?  Read on!

  1. How to repeat header rows / page titles in SSRS (this blog)
  2. Using the Group Pane to Repeat Page Titles
This blog has 0 threads Add post