SSRS Tablix header not repeating

0
votes

I'm working on SSRS tablix and when I have data more than one page, my tablix header is not repeating on the next page.

I set RepeatOnNewPage = True and KeepWithGroup = After

Here is the screenshot. In the below report, the 3rd column (Sales Team) has more data and it went to the 2nd page. But the header not showing on the second page. Only blank row appearing.

Note: There is no default group as I've put another table in the column to filter data based on value. Is that causing issues?

enter image description here

enter image description here

enter image description here

1
reporting-servicesheaderssrs-tablix

1 Answers

0
votes

Under the column Groups, click on the Advanced Mode

enter image description here

This will then show some static elements under the Row Group.

Select each static element and ensure RepeatonNewPage property is set to true. Note, this needs to be done on all the static elements under the column group.. else it will not run

enter image description here