** We are self-hosted **
For the life of me I cannot get column headers to repeat on each page.
I tried "fixed data":
and of course repeat row on each page:
Neither is working. Can anyone help?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Okay so when I try to do the solution above in a report that has a grouping I get this error:
Severity Code Description Project File Line Suppression StateError [rsInvalidRepeatOnNewPageOnColumnTablixMember] The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.
Any thoughts?
Ashley Elliott (Past Member) said:Okay so when I try to do the solution above in a report that has a grouping I get this error:
As I search, I see that this is a frequently occurring error, over multiple years and versions of SSRS, so we can be sure there are multiple causes, and that MS's documentation is poor. However, one suggestion I see repeatedly is to set "Fixeddata = True, RepeatOnNewPage = True" on the Row group, rather than the Column group.
https://social.technet.microsoft.com/Forums/en-US/6ed9ff5c-caa6-46ed-8932-21480275cb51/cannot-repeat-static-column-groups-in-report-builder?forum=sqlreportingservices