Tuesday, October 9, 2012

Repeating Tablix Column Headers with SSRS 2008



Repeating Tablix Column Headers with SSRS 2008
 
There seems to be an issue with repeating column headers using SQL Server 2008 Reporting Services. Typically you would highlight the row, right-click and select properties then you would be able to set the property for RepeatOnNewPage to True. I tried it and it does not work for SSRS 2008 R2.


Work Around:
Click on Black Arrow, at Right Side In your grouping pane, select advanced mode, then select your outermost static row; Click F4 or open Properties Window. You should then see the "RepeatOnNewPage" property and KeepwithGroup.
Set KeepwithGroup as --- After (None, Before and After)
RepeatOnNewPage ---True
 
Happy Reporting!!!

No comments:

Post a Comment