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:

  • KeepWithGroup: After
  • RepeatOnNewPage: true
  • FixedData: true to keep headers visible
  • Advertisements
    Categories: Reporting Services
    1. rex
      31 May, 2010 at 3:55 am

      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. FiestyGoat5150
      8 July, 2010 at 7:30 am

      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. Nes
      16 February, 2011 at 1:57 am

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

      • itch
        23 March, 2011 at 5:28 am

        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?

        • TERRENCE
          18 June, 2011 at 2:07 am

          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. Vishanth
      11 April, 2011 at 11:11 pm

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

    1. No trackbacks yet.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: