SSRS 2008 R2 repeat headers on pages

As of SQL Server 2008 R2 the way to make headers of tablix’s repeat has changed considerably.

I suggest you read the post here:
http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx

In short all the documentation I found suggested you needed to turn on the “Advanced Mode”.

Advanced mode is a bit hard to find.

See the bottom of your design space you should see the heading:

  • Row Groups
  • Column Groups
  • and keep looking right and you see the innocent little black down triangle. Click that and choose advanced mode.
  • Click on the static elements and it will highlight a cell in the report, this identifies the element you are attempting to change.
    To make a heading repeat. Click on the static member for the header row/s of you tablix, view the properties pane and set these properties:

  • FixedData: true (to keep headers visible when scrolling)
  • KeepWithGroup: After
  • RepeatOnNewPage: true
  • Edit – Nov 2011
    So its been a year or so since I wrote this and in a case of dog fooding, I had to fix up a report and I hit the same error as listed by nes, itch and Terrence below.

    Here is what the header Row Groups looked like in my report.

    Each one of the static rows between “table1_eventId” and “rsvp” are rows in a group header in the report. When you click on the static row, the element in the report is highlighted

    So I followed my own instructions and setup the row group properties on the static row immediately above rsvp as per my instructions, ran the report and got a similar error to Terrence.

    Delving into the issue there are two possible solutions:
    Solution 1
    Assuming that you need all the header rows to repeat on each page, then you need to configure EVERY static row in the row groups in the same way, (every row between table1_EventId and Rsvp). Get one of the properties different and you get that error.

    Solution 2
    Assuming you don’t need the entire section above to repeat on every page. I needed to only have the table header row repeat. (the last static row prior to RSVP contained the details of the table column headers).
    I right-clicked on the RSVP row Group, chose Insert Row –> outside Group – Above. This inserted a single blank row. Copy the header columns from the row that is now in the outer group, and paste into the new row that appeard. Delete the previous header row. Now follow the instructions above. As there is only 1 row then the repeating header instructions above will work.

    Here is what the row groups looked like after solution 2. The static row between rsvp and table1_details_group is the header as highlighted and this is where you can setup the single repeat header proper

    The trick is that to have the header repeat you have to update every row at a level in the row group to have the same settings.

    10 thoughts on “SSRS 2008 R2 repeat headers on pages

    1. When the columns are set to be dynamically visible depending on some Hide property expression you can’t make row header to repeat. Is there any way around it ? Many thanks.

    2. Thanks for the walkthrough. Several other posts said the same thing but i couldnt figure out exactly where this “advanced mode” was. thanks again! works great.

    3. This didn’t work for me..The error I got after changing the properties was this..

      The tablix ‘Tablix2’ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the KeepWithGroup property set to “None”.

      1. I get this error too.
        The tablix ‘Tablix2′ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the KeepWithGroup property set to “None”.

        anyone?

        1. I get this error too.
          The tablix ‘Tablix2′ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the KeepWithGroup property set to “None”.

    4. Thanks for the that. Several other posts said the same thing but i couldn’t figure out exactly where this “advanced mode” was. Finally got the innocent little black down triangle 🙂 thanks again!.

    5. TERRENCE :

      I get this error too.
      The tablix ‘Tablix2′ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the KeepWithGroup property set to “None”…

      I should clarify.

      The Advanced mode is used when working with Row headers.
      When you have advanced grouping you end up with “Column Groups”

      To get column groups to repeat you can use the overriding “Repeat headers on new page” tick boxes in the tablix properties.

    6. In the scenario of wanting to have repetition of both column AND row headers when scrolling, I discovered that
      a) in the design environment, it doesn’t appear to work e.g view report > scroll right and the left most col headers are still visible >scroll down and the left most col headers are lost at the top
      b) in the ReportManager and ReportServer environment, it DOES work after all 🙂

      Took me 90mins to discover this and didn’t find it anywhere else on the web

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.