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:
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!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
180 | |
96 | |
79 | |
77 | |
74 |