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 | 9 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.

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 9 comments

Comment added on 06 September 2011 at 11:32 GMT
Nice post, this as it helped me out.

What were they thinking of with that Advanced button eh? Esoteric or what?

In future releases MS will now fix this issue and people following the system you have mentioned will still have to be covered so that will be yet another feature that can be performed in (many) totally different ways within the same application. Alternatively they will remove one of the methods and then people will hotfix their report servers and the reports will break. Brilliant!

I think this was probably caused by MS making all reports use the tablix rather than keeping the table. Was this a good move?

This demonstrates the problem of rushing out releases without proper testing.

Thanks to you for your help

Comment added on 08 September 2011 at 11:35 GMT
Thanks for this - it works fine for simple table with no groupings, but I'm finding it impossible to repeat my success with a table that has a group.  For a simple style of table - one header row and one row of details, but where the first column is the group-by - the advanced mode reveals multiple "Static" row elements.  Setting any one or all of these to repeat on new pages doesn't seem to do the trick (as it certainly did for an un-grouped table).
Any ideas... am I missing something obvious?
Comment added on 08 September 2011 at 11:47 GMT
Oops - just spotted my problem after creating some similar grouped reports from scratch... the first "(Static)" row in my problem report didn't have the KeepWithGroup option set to "After"... doing this makes it all work nicely.  Not sure how this got set that way, as it seems to be set by default for the first static item if I create a new report from scratch.  Hope this might help someone with a similar problem.

Thanks again for a clear description of how to get this working.
Comment added on 16 September 2011 at 20:15 GMT
Am I missing something?  All I can see on the blog post right now are the steps that do not work and a link that seems like it should point to the steps that *do* work, but it just links back to the same page.

Any help?
Comment added on 18 September 2011 at 20:06 GMT


I have no idea what went wrong with the blog, but I've no corrected it.  Thanks for pointing this out.


Comment added on 20 April 2012 at 05:43 GMT

But when you export your report in Excel format and look that in print preview then you will not see
Table header on each page but it works for pdf format. If you have any idea which also works in
Print version of Excel then please let me know.

Thanks in Advance
Saurabh Kasyap

Reply from Andy Brown
I don't, I'm afraid - anyone else?
Comment added on 24 July 2012 at 21:49 GMT
I, too, would like to say thanks for this post.

I haven't worked with SSRS since v 2005 (and not much then), but this one was obtuse to say the least.

Not sure how much poking around would have been required to guess the "advanced" + "static" hoo ha.

Thanks again,
Comment added on 31 July 2012 at 18:27 GMT

I have a issue that i'm not getting header section and table header  of report builder on each page of excel sheet when we export from reportbuilder, it's working fine in reportbuilder problem is when we export it to execl sheet

i enabled these things so far in my report

 Advance mode,selecting static group of a row applied below properties,
in tabilx properties
enabled below settings
 Repeat header row for each page
keep header visible while scrolling

please reply asap


Reply from Andy Brown

Apologies for the delay in replying (a holiday intervened).  Have you fixed this yet?

Comment added on 12 September 2012 at 17:43 GMT
I have found an easier way is to open a header and build the title in the header, then it will repeat on each page.
Reply from Andy Brown
True, but it won't automatically line up with the table columns (so if you change the column widths or move the table, you'll have to juggle about with the position of the header).

A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.