March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I couldn't find a channel for Power BI Report Builder so apologies if this is the wrong forum.
I'm new to building paginated reports and I've struck a problem that's probably quite easy to fix.
My dataset is a table with about 20 rows. I want one row from the table to appear on each page, which I've done by checking this box in the row group properties:
This is fine except the column headers of the table only appear on page 1. From what I can gather the way to pin the column headers on each page is this option in the table properties:
However, it doesn't work. I've tried ticking all the boxes in the Row Headers and Column Headers sections but nothing works.
Can anyone tell me how to solve this? Thanks in advance.
Solved! Go to Solution.
Yes, this is the right forum. Take a look at this blog to check if you've included the static rows:
https://www.ptr.co.uk/blog/ssrs-repeat-page-headers-every-page
There's more general resources on grouping and paging here:
Thanks. I got it sorted in the end. I think I may have come across the same blog, or a similar set of instructions elsewhere, which worked.
Yes, this is the right forum. Take a look at this blog to check if you've included the static rows:
https://www.ptr.co.uk/blog/ssrs-repeat-page-headers-every-page
There's more general resources on grouping and paging here:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |