Home > Reporting Services > SSRS 2008 R2 repeat headers on pages

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.

    VN:F [1.9.22_1171]
    Rating: 0.0/10 (0 votes cast)

    Categories: Reporting Services Tags:
    1. rex
      May 31st, 2010 at 03:55 | #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.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    2. FiestyGoat5150
      July 8th, 2010 at 07:30 | #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.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    3. Nes
      February 16th, 2011 at 01:57 | #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”.

      VA:F [1.9.22_1171]
      Rating: +1 (from 1 vote)
      • itch
        March 23rd, 2011 at 05:28 | #4

        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?

        VA:F [1.9.22_1171]
        Rating: +1 (from 1 vote)
        • TERRENCE
          June 18th, 2011 at 02:07 | #5

          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”.

          VA:F [1.9.22_1171]
          Rating: 0 (from 2 votes)
    4. Vishanth
      April 11th, 2011 at 23:11 | #6

      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!.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    5. jcrawfor74
      November 23rd, 2011 at 21:01 | #7

      @Nes
      See edit above. I hit the same problem and hopefully have a solution. (I realise this is a long time between posts)

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    6. jcrawfor74
      March 26th, 2013 at 22:01 | #8

      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.

      VN:F [1.9.22_1171]
      Rating: -1 (from 1 vote)
    7. jcridge
      September 6th, 2013 at 01:45 | #9

      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

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    8. MunishB
      May 15th, 2015 at 20:27 | #10

      Many Thanks Solution 2 worked a treat.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
    1. No trackbacks yet.