Thursday, February 16, 2012

Show Column Headers on every page in SQL Server Reporting Services

To repeat coulmns on every page of report on SQL Server Reporting Services you need to:
  • select tablix
  • set RepeatColumnHeaders property to True
Unfortunately, this does not work for some reports. In that case you need to:
  • select tablix
  • view Column Groups/Row Groups pane
  • this pane contains a little arrow on the right side that allows you to enter Advanced mode. Select it.
  • You will see one or more (Static) row groups before your regular (Details) group. You need to set their RepeatOnNewPage property to True. 

I've done this from Visual Studio 2008 on SQL Server 2008 R2 Reporting Services report.

No comments:

Post a Comment