Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
willpage
Helper II
Helper II

Persistent Column Headers in Paginated Reports

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:

willpage_0-1681338453790.png

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:

willpage_1-1681338565536.png

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.

1 ACCEPTED SOLUTION
Jon-Heide
Employee
Employee

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: 

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/display-row-and-column-header...

 

 

 

View solution in original post

2 REPLIES 2
willpage
Helper II
Helper II

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.

Jon-Heide
Employee
Employee

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: 

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/display-row-and-column-header...

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.