Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
16.6k views
in Power BI by 11 11 15

I created a paginated report using Power BI Report Builder, The header of the table exists just on the first page, and I want to show the table header on every page when scrolling down to be fixed On each page! How I can do that?

fixed table header in SSRS reports

 

 


1 Answer

1 like 0 dislike
by 24 26 40
selected by
 
Best answer

To repeat the table header for each page in Power BI Paginated Report, you have to set RepeatOnNewPage to true in Tablix properties.

Steps

  1. Go to the view tab > Grouping
    Show grouping in SSRS report

  2. At Column Groups, Click down arrow > select Advanced mode
    Column Groups advanced mode in SSRS

  3. Select Static > Properties.
    tablix Properties

  4. At Tablix properties, change the value of RepeatOnNewPage from false to true
    fixed tablix header in SSRS

If you don’t ask, the answer is always NO!
...