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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.