BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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
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:
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!
- How to repeat header rows / page titles in SSRS (this blog)
- Using the Group Pane to Repeat Page Titles