Friday, January 12, 2018

SSRS - Repeat rows on each page (Does not work if any group is hidden)

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/display-row-and-column-headers-on-multiple-pages-report-builder-and-ssrs


  • This only works for the Tablix Header Row outside of your Groups. 
  • Group headers will not repeat on each page.
  • Remove any unnecessary columns on the left to ensure you can see the correct Static fields in the advanced mode
  • Groups>Advanced Mode>Select Field from group list on left, Properties>Keep together=No, Keep with group=After, Repeat on new page = Yes

SPECIAL NOTE
On SQL 2012 and lower, if you hide any group, it breaks the row repeat functionality.
Once any group is hidden, the rows will no longer repeat on the report.
HOWEVER if you enable a visibility toggle for all hidden groups, the header will repeat.

No comments:

Post a Comment