This is particulary tricky using Tablix…
Give a look at this link: what to do when the RepeatColumnHeaders Property in a Tablix isn’t working
In Advanced Mode select the Static Row Group you want to repeat and set these properties:
.RepeatOnNewPage = True.KeepWithGroup = After.FixedData = True
It is also recommended to set Tablix property .RepeatColumnHeaders = True in case Microsoft will release a patch to this strange behaviour.
To get to Advanced Mode:
- make sure you can see the row groups and column groups window
- over to the right hand side of the column groups list box, there’s a small downward arrow
- click on this to reveal the
Advanced Modecheck box
