** 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
**SOLVED**
Okay so, I have messing with this a lot over the past ten days and I found that the work has to be done on the ROW GROUP in order to get the column headers to repeat. This makes no sense to me ... but it does work. Doing what is in the link Chris posted above on the static times in the row group does the trick.
Ashley