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:
Solved! Go to Solution.
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?
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.
@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.⚡
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:
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.