Repeating Tablix Headers In SSRS 2008

So I’ve been trying to figure out haw to repeat headers in a Tablix.  I don’t do a lot of SSRS stuff and the report I’ve got is moderately complex, it does a bit of an involved grouping situation with a few sub reports for details and then a Tablix to repeat individuals under each details section.

The Tablix has Repeat Column/Row Headers properties in the property pane but they are useless.  During my searches I saw something about these properties being for when the report is too wide, not too long.

Anyways, at the bottom of your report designer there should be the grouping info pane.  Click on the black arrow in the upper-right corner of the pane to enable “Advance Mode”  Doing this shows static group items in your grouping pane for things like header rows.  Find the static item that corresponds to your header row and check the property pane.  There will be a “RepeatOnNewPage” property, set it to true and headers should repeat, at least they did for me.

Hint: If you can’t figure out which static grouping could be your row header, watch the report designer as you click on the different groups, it will highlight the one you just selected in the designer.

54 thoughts on “Repeating Tablix Headers In SSRS 2008

  1. epoxy flooring ma

    Greetings I am so delighted I found your weblog, I really found you by accident,
    while I was looking on Digg for something else,
    Anyways I am here now and would just like to say kudos for a marvelous post and a all round exciting blog (I also love the theme/design), I
    don’t have time to look over it all at the moment but I have
    saved it and also added your RSS feeds, so when I have time I will be back to read a great deal more,
    Please do keep up the superb job.

  2. Lurlene

    Great weblog here! Additionally your site lots up fast!
    What host are you the usage of? Can I am getting your associate hyperlink to your host?
    I desire my website loaded up as fast as yours lol

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>