SQL Serverous

SQL Serverous

Alan Wood  //  Professionally: SQL Server consultant
Personally: Geek, musician, sports fan (avid follower of Motherwell in the SPL and the 49ers and Dolphins in the NFL. Also follow the SF Giants in MLB).

Jan 7 / 7:18am

Column headings do not repeat in SSRS 2008

I've just stumbled upon an odd issue with the Tablix control in SSRS 2008.  I deployed a report on a server a few weeks ago and it is now reporting on enough data to make it span multiple pages.  I wanted the column headings to appear on all pages, not just the first.  However, when I set the RepeatColumnHeaders property on the Tablix to be true, the headings still did not appear on the next page.  After a bit of playing around I enabled Advanced Mode in the Grouping Pane, and had a look at the properties for the top (Static) group in Row Groups.  Under Other, there is a property called RepeatOnNewPage.  Setting this to True made the column headers appear as required.  OK, so that's fine, but I can't help but think that this a a bug in SSRS 2008, and should be fixed by MS.  Looking through the RDL file itself, I can't find anything that would cause the RepeatColumnHeaders property not to behave as expected.

The "Header should remain visible while scrolling" option does not appear to work either; I haven't yet found a workaround for this.

Loading mentions Retweet

5 comments

Feb 20, 2009
Paul said...
Not sure if you ever fixed your problem, but to get the column headers to remain visible you need to set FixedData to True in advanced mode.
Feb 21, 2009
Alan Wood said...
Thanks for that Paul. It's not obvious from the name!
Jul 31, 2009
Anon said...
Worked great for me. Thanks!
Sep 01, 2009
ssrs08 said...
Set FixedData to True, & uncheck the checkbox- "Headers should remain visiable while scrolling" in the Tablix Properties & the headers will remain visible, THANK YOU for your help and post I never would have found it.
Oct 06, 2009
Sam said...
Thank you ssrs08! The key was unchecking "headers should remain visible". You gave me the answer after days of trying.

Leave a comment...

 
Got an account with one of these? Login here, or just enter your comment below.
Posterous-login    Connect    twitter