** 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
Ashley Elliott (Past Member) said:For the life of me I cannot get column headers to repeat on each page.
I've re-learned this every few years for about a decade now. Most recently I found this article useful:
https://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx
I have also re-learned that every few years. So very much not the first place you would go to look.
**SOLVED**
Thank you! That worked.
Ashley
We need a wiki for these things. I'm always forgetting.
You know... Community Docs Wiki
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?
It's like rubbing an old lamp
Sadly, every few years, when I find that I've forgotten how to do SSRS column headers, I also find that MS has (very slightly) changed the way it's done, so any Wiki would likely be as out of date as my own memory and/or saved bookmarks. [insert animated gif of Sisyphus pushing a boulder uphill]
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
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.