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.
- How to repeat header rows / page titles in SSRS (this blog)
- 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:
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:
The titles only appear by default on the first page.
The answer should be simple:
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!
This blog has 9 comments
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
I have no idea what went wrong with the blog, but I've no corrected it. Thanks for pointing this out.
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
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
Apologies for the delay in replying (a holiday intervened). Have you fixed this yet?
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.