Tablix: Repeat header rows on each page not working

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in Report Builder (I'm using v3.0). Is this true? If not, is there something else that needs to be done?

It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn't work.

Instead, you need to:

1. Open Advanced Mode in the Groupings pane at the bottom section of your Report Builder window (Click the down arrow to the right of the Column Groups header and select Advanced Mode).

2. In the Row Groups area (not Column Groups), click on a Static group, which highlights the corresponding textbox in the tablix. Click through each Static group (if you have multiple) until it highlights the leftmost column header. This is generally the first Static group listed.
3. In the Properties window, set the RepeatOnNewPage property to True:

• 

  (If you don't have the Properties window open, click the View tab at the top of Report Builder and check the box for Properties):

• 

4. Make sure that the KeepWithGroup property is set to After.

The KeepWithGroup property specifies which group to which the static member needs to stick. If set to After then the static member sticks with the group after it, or below it, acting as a group header. If set to Before, then the static member sticks with the group before, or above it, acting as a group footer. If set to None, Reporting Services decides where to put the static member.

Now when you view the report, the column headers repeat on each page of the tablix.