Forum Discussion
Report Builder does not repeat column headers on subsequent pages
I designed a simple report in Report Builder.
Now I need to repeat the column headers on all pages. I checked this Tablix property:
I also set the RepeatColumnHeaders property to True:
The report, however, is not repeating the column headers. I've exported it to both Word or Excel and the column headers are not repeated. Is there something else I need to do in the design of the report to make this work?
I downloaded the Report Builder program last week, so I'm using the latest version:
Thanks!
parry2k I take everything back,. Anonymous The setting of KeepWithGroup = after and RepeatOnNewPage = true needs to be done on the static members in the ROW GROUPS pane. Here is an explanation with screenshots.
15 Replies
youtube.com/watch?v=KTkKxpOu23Q The solution is very well explained in this video.
This is the winner!! 😍
so much excellent
thanks man😉
I see that the section of the page suggested by parry2k says that the KeepWithGroup and RepeatOnNewPage settings are for column heading groups. I don't have those in my table, so I removed them and the error above went away. However, I'm still not able to get the column headings to repeat on my simple table. Maybe it's a bug in the latest release. Has anyone gotten this to work recently?
I don't think you could make this less intuitive if you tried. Come on MS. You can do better.
Anonymous this is the solution, following the steps at this link Show Row & Column Headers on Multiple Pages (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous I had this going for myself when I started using Paginated reports a few years ago, not sure why it shouldn't work for you. Try to turn that option off.
I tried this again by creating a very simple table manually and entering the data. It has only two columns:
Even on this very simple table, the "Repeat Header Columns on Each Page" setting has no effect when either checked or unchecked.
Has anyone been able to repeat column headers on multiple pages, or is this a bug?
Thanks,
Rick
