36

Here is my tablix properties

enter image description here

enter image description here

enter image description here

What Am I missing? Please help thanks!

SHINHAN
  • 685
  • 2
  • 12
  • 28

3 Answers3

96

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 Mode check box

advanced mode

tezzo
  • 10,858
  • 1
  • 25
  • 48
  • 1
    When the text in any of the column is so large that it move to the next page then the header column will not repeat. Is there any solution to this issue? – Manprit Singh Sahota May 16 '19 at 06:00
  • I have two headers, I want to repeat top 1 but not the second one, any help on this? – M A K Aug 17 '20 at 09:15
  • Some of you might have error while compiling, instead of adding modifications to Column group (Static), try with row groups(Static)..worked for me. – Kevin Mbugua Oct 26 '21 at 12:05
19

Works for me: RepeatOnNewPage = True

enter image description here

InitK
  • 1,261
  • 13
  • 21
Julian50
  • 2,462
  • 1
  • 21
  • 30
0

Here is a new solution I just remembered:

Move your table header to the report Header, sample please see as the picture. That will maker sure your title is repeat in all pages for all situation. enter image description here

charles chen
  • 82
  • 1
  • 9
  • This will only help if you only have 1 table in your report. If you have more than one talbe you'll need to go with a different solution – Mike Jan 12 '19 at 02:50
  • 1
    The report designer won't let me add a matrix / Table to the report header – Maxter May 27 '19 at 19:40
  • I have two headers, I want to repeat top 1 but not the second one, any help on this? – M A K Aug 17 '20 at 09:16