Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to Solution.
@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.
youtube.com/watch?v=KTkKxpOu23Q The solution is very well explained in this video.
This is the winner!! 😍
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
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?
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I selected KeepWithGroup = After and RepeatOnNewPage = True for all the columns as the link suggests. But now I get this error:
When I set KeepToGroup = None, I got an error stating that I should set the RepeatOnNewPage to False:
@Anonymous I have the exact same situation here as you.
@parry2k I do believe that this is a bug.
@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.
Hi,
The solution is great and applied for a Table, but its likely it does not work for a Matrix?
You need to pick the Row groups (on the left), not the Column groups (on the right), even though you start by clicking the dropdown in Columns. works with matrix tables
Thanks for the solution, it work for me too!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
82 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |