Reporting Services: Tablix RepeatColumnHeaders doesn't work on some reports

I_Have_the_Hat_4296 0
Viewed 37201

So I've got various reports that consist of a DataSet rendered in a Tablix... pretty garden variety stuff. There is a property for the Tablix control named RepeatColumnHeaders, which I have set to True for each report in question. The explanation for this property states “Indicates whether column headers are repeated on each page on which part of the data region appear.” Sounds pretty straightforward, but on some reports it works and on others it does not. I can't seem to find what's different about the reports that might affect this. On one report where the headers do repeat, there is some fairly arcane grouping mojo, but in an example where it doesn't work the Tablix only has one level--no grouping. I would expect the multi-nested one to be the problem, not the flat one.

Maybe it's a different problem altogether. I threw together a simple Tablix rendering SELECT * FROM Foo, accepted all the default values, which results in RepeatColumnHeaders being set to False, and lo and behold the column headers do repeat for that report... Grrr.

Any insights greatly appreciated.

reporting-services
7 Answers

It's a bit wonky from what I've managed to dig up. In your grouping pane, select advanced mode, then select your outermost static row. You should then see the "RepeatOnNewPage" property.

Update: finding Advanced Mode:
The comment by @HCL links to the other answer by @user359904, that has the info on how to find and enter Advanced Mode:

  1. Select the tablix
  2. Below the report are "Row Groups" and "Column Groups", all the way to the right of "Column Groups" is a small downward arrow.
  3. Click the arrow, choose Advanced Mode.
beernuts_547620

Sorry to beernuts for un-marking your response as the answer; I hope you get to keep the rep points.

The plot thickens. In three tests I found a 1:1 correlation between using the wizard to create a report and getting the desired header behavior, as well as between not using the wizard and not being able to achieve the desired behavior. From there I diff'd the rdl files for a working and non-working example and found this element:

<RepeatOnNewPage>true</RepeatOnNewPage>

In the document at:

Report > Body > ReportItems > Tablix > TablixBody > TablixRowHierarchy 
  > TablixMembers > TablixMember

I added the same to the non-working rdl and the headers started repeating.

I cannot, however, find a setting, property, etc in the designer that toggles this. It does not seem to correspond at all to the obvious properties as described previously. Is it just an artifact of the wizard? Fortunately it's a fairly easy work-around as I couldn't face recreating a dozen reports using the wizard.

I_Have_the_Hat_42960

In your reports where the header doesn't repeat, did you delete the default header row in the tablix at any point? Once I did that, no matter what setting I tried, the header in the tablix wouldn't repeat. I had to re-create the tablix to get it to work.

beernuts_547620
Related