Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

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 article)
  2. Using the Group Pane to Repeat Page Titles
Posted by Andy Brown on 26 July 2011 | 9 comments

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!

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 article)
  2. Using the Group Pane to Repeat Page Titles

Comments on this blog

This blog has 9 comments:

Comment added by DavidBridge 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

Dave
 
Comment added by Keith 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 by Keith 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 by Jeff L 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 by Andy Brown on 18 September 2011 at 20:06 GMT

JeffL

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

Andy

 
Comment added by saurabh 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 (blog author)
I don't, I'm afraid - anyone else?
 
Comment added by jeffa00 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,
jeffa
 
Comment added by ulammatha 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,
repeatOnNewPage-True
KeepWithGroup-After
in tabilx properties
enabled below settings
 Repeat header row for each page
keep header visible while scrolling

please reply asap


 

Reply from Andy Brown (blog author)

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

 
Comment added by LostintheWood 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 (blog author)
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).

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.