DEV Community

APK
APK

Posted on • Updated on

How to enable repeat header in all pages of ssrs report/ power bi report builder

hi, all you need to do is follow the step by step instructions

1) open your ssrs report in report builder

Image description

2) make sure to tick the properties and grouping options in view

Image description

3) select the tables which you wanted to repeat the header columns in each page

Image description

4)from the column groups menu select advanced mode from the dropdown

Image description

5) from the row groups select the first static tab

Image description

6) you will get a property window called tablix member(make sure the property check box is checked as i mentioned in 2nd step)

Image description

7)make sure the keepwithgroup set to after and repeatonnewpage set to true

Image description

8) please note that it will work for table . but in some cases like matrix if its not working please make sure to enable repeat column header option in that particular tablix property

Image description

And now your report is ready to repeat the header in all pages!!!!!

Top comments (0)