topic Re: Report Builder Column Headers are Not Repeating on Additional Pages in Report Server

Report Builder Column Headers are Not Repeating on Additional Pages

EH_MW — Fri, 19 Apr 2024 13:01:44 GMT

Hello,

I am creating a paginated report using Power BI Report Builder. My report spans numerous pages so I want to display the column headers (name of each column) on every page. When I run the report in Report Builder, it does this automatically, but it does not when I publish it to Power BI. I have gone into "Tablix Properties" and selected both the "Repeat header rows on each page" and "Repeat header columns on each page" (separately and together), but neither of these have any impact after publishing. Is this a bug or am I doing something wrong?

Thanks!

Matt

Re: Report Builder Column Headers are Not Repeating on Additional Pages

Anonymous — Tue, 23 Apr 2024 01:43:26 GMT

Hi EH_MW ,

Please refer to the document abhout more details.

Show row and column headers on multiple pages in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.
In Column Headers, select Repeat header columns on each page.
Select OK.

I have also found a similar post, please refer to it to see if it helps you.

The setting of KeepWithGroup = after and RepeatOnNewPage = true needs to be done on the static members in the ROW GROUPS pane.

Solved: Report Builder does not repeat column headers on s... - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report Builder Column Headers are Not Repeating on Additional Pages

EH_MW — Tue, 23 Apr 2024 12:24:07 GMT

This video solved my issue:

https://www.youtube.com/watch?v=KTkKxpOu23Q

Re: Report Builder Column Headers are Not Repeating on Additional Pages

jostnachs — Thu, 26 Sep 2024 14:57:11 GMT

This works fine in my report builder. but when the report is exported as excel, the column headers are not frozen while scrolling