Getting SSRS in SQL 2008 to repeat the headers on every page can be a time consuming task. Especially since the Tablix property window lets you set the checkboxes to repeat the Row and or Column headers. Nothing happens however if you set them.
You will have to digg into the Advanced settings at group level in order to make the headers repeat on all pages. The image below shows how to access the advanced settings in the group.
After turning on the Advanced Mode the region in the designer will show additional info and allows you to set the right values to get repeating headers: See the image below
If you ommit these settings on the static row the preview will give you an error. So after setting these values there is one more thing to do and that is set the property on the Details row as shown below:
This will do the trick for you and SSRS will now reproduce the headers on each page of the report.
July 8th, 2010 at 07:50
This note with snapshots is really handy. Thanks for the info.
September 21st, 2010 at 14:05
Thank you soooo much for the screen shots I was not going into Advanced Settings correctly and with your screenshots I finally worked out what I was doing incorrectly. Thanks again…. Off I go now to update all my list of reports.
September 23rd, 2010 at 00:00
snapshots really helps a lot. Thank you very much.
April 11th, 2012 at 16:14
Thanks for posting.
April 18th, 2012 at 14:01
Thanks a lot! Found an article which was much more complicated than yours for the same effect. I am really happy I found your article! Brilliant!
But I just can understand why this options is hidded this way…..?
June 28th, 2012 at 16:29
OMG, so easy, no other site explained that you had to do the second step with the details!
August 28th, 2012 at 11:20
Thank you very very muuuuuuuuuuuuuuuuuuuuuuuuuch
November 23rd, 2012 at 01:50
I also needed KeepWithGroup property set to After for this to work
April 10th, 2013 at 23:20
KeepWithGroup set to “After” for the static row is the key; FixedData did not have to be set to True for it to work for me.
March 5th, 2013 at 18:24
That was very helpful! I did find that I had conflicts if I set the tablix properties first, and you have to delete the group but leave the rows in order to make them static.