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.

46 thoughts on “Repeating Tablix Headers In SSRS 2008

  1. Gurjit

    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.

    If the above solution doesnot work then you have to check your tablixrowhierarchy.In tablixrowhierarchy if any extra tablix member is there between one empty tablix member and group tablix member then you must have to remove that extra tablix member.

  2. Danielle

    This works perfectly! I’ve been trying to figure this out for months and could never understand why the repeat column/row headers failed to work.

  3. anthony robinson

    This worked for me partially. I have created the most SIMPLE report and I STILL cannot get column headers to repeat while scrolling! It is a table – not a matrix mind you. I literally have a one column report. It has a column called STAFF. I click the arrow to go to Advanced Mode.

    There is one row in the Column Groups pane – STATIC. There are two rows in the Row Groups pane – STATIC and DETAILS.

    If I highlight the one row in the Column Groups pane and set the RepeatOnNewPage value to true, I get an error:

    The tablix Tablix6 has an invalid tablixmember. All tablixmember elements in a tablixcolumnhierarchy must have the RepeatOnNewPage property set to false.

    If I set the RepeatOnNewPage property of the static row in the row columns grouping pane, the header repeats on a new page, but does not stay visible when I scroll.

  4. Anumula

    In the tablix properties set repaet header to False. In the grouping pane set for row groups set RepeatOnNewPage to True, KeepwithTheGroup to After, and KeepTogether to True for Static.

  5. sneman

    This did work for me. thanks for clear step by step info on how to access the Grouping pane and how to turn on those properties using the property pane. Before reading this,I tried rt.clicking on the static row to access the property pane( as one would expect).It didn’t work, I was almost abt to give up on this trick. But your comments helped me

  6. Bruce

    Your suggested solution above did not work, as Report Builder 3.0 issued the following error message after implementing your suggestion:

    “The tablix ‘Tablix1′ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.”

  7. Anthony Robinson

    I have followed these steps EXACTLY, and I am still unable to get column headers to repeat.

    Seriously, Microsoft…I don’t know what possessed you to make this change but it completely sucks!

    I have made the changes for the STATIC grouping
    I have made the settings changes for the Tablix properties

    Nothing is working

  8. anthony robinson

    I stand corrected…did finally get it to work…but still zero luck with keeping column headers visible while scrolling.

    I still think these changes by SSRS team/Microsoft team kinda stink.

  9. Ken Taylor

    On keeping the column headers visible when scrolling…

    In addition to checking the boxes mentioned above for repeating the column header on multiple pages, you need to do the following:

    1. Open “Tablix Properties” and UN-check any previously checked boxes under column headers, as these apply to “dynamically grouped” columns, and will possibly interfere with any “static” column headers.

    2. Return to the same properties page listed previously in the article, the one where you checked the
    “KeepTogether”, “KeepWithGroup” and “RepeatOnNewPage” boxes, and check one additional box: “FixedData”. That should do the trick and give you repeated column headers on each page that are also visible when scrolling.

    Cheers!

  10. Chris

    The report designer folks need to go on a long holiday. Preferably a permanent one as they seem to make it harder and more overly complicated with each iteration…

  11. Brian

    I’ve been looking for a solution to this issue for a while, and I was hoping that upgrading to R2 would have resolved this but this worked great for me.

  12. Ravi

    I have the same issue my report has groups in it and i am not able to see the column headers on all pages except the 1st one. I followed all the above mentioned solutions but fruitless. Can any one help me on this? my problem is when i clicked on the static i get the highligted in design view only on 1st two columns but i dont get for other columns . Still i tried deploying the report and checked but i didnt even get the 1st two columns. Please help..

  13. Bj

    Not certain if this will help anyone but I have a basic report with a basic table. In the table I have the fields Version, Bill Number, Title, Position as column headers. In the Advanced Groups Pane at the bottom, I tried desperately to select each STATIC column header and set the “RepeatOnNewPage” property to true, only to get the same error everyone else was getting. I then tried to set the “RepeatOnNewPage” property on the VERY FIRST column header which was Version and also of which I am grouping by. Only deal is this shows as the FIRST STATIC item in the Row Groups section of the Advanced Groups Pane. Said what the heck, set the property “RepeatOnNewPage” to true (making certain all other static items in the Column Groups section were set to false) and I’ll be damned! Worked like a charm. Seems that if you’re grouping, you should set the properties of a single instance, rather the group as a whole! Or maybe I’m just absolutely wrong but lucked up! I hope this saves the last bit of hair on some poor developers head, code on guys…..

  14. Andy Brown

    Thanks – what a bizarre way to do this! Bring back SSRS 2005 (at least for grouping in tables). Gauges, indicators, etc are all very nice, but I don’t like the new way of grouping rows and columns!

  15. Paul

    Hello, I tried this solution on a straigt forward tablix no grouping and it works! BUT in my case i have a tablix with a grouping so my tablix row groups consist of:
    1) static
    2) static
    [ group 2
    static
    details 7
    static

    i have tried to change the attribute values for every static group without any success there is no repeating header showing up. I have installed SP2 and also the groups are not highlighted in designer mode if i want to determine which group belongs to what static field.

    any help would be great,

    Thx Paul.

  16. KSteinmetz

    Thank you thank you thank you Anumula! And also to the original poster for helping me to “see” the column and row groups in the designer. I didn’t even know I had groups!

  17. SeanG

    followed the steps above (advanced mode, then on static repeat on every page) which fixed the first report. the second report i was having the problem wouldn’t work until i went into the group, and added new row outside the group, copied all the header text to it, it repeated so i then removed the original header row which only output on the first page.

  18. Anthony Smuts

    hi all, is it possible to repeat column headers every time my group changes? I don’t require a Pagebreak as the data needs to be displayed on 1 page.

  19. Amar

    We have to design a rdl like below. Please suggest on this. Its urgent.

    Start Time End Time Appointment details
    8:00AM 5:00PM ABC

    Name Check In Name Check In
    A1 Y A2 N
    A3 Y A4 Y
    A5 N

  20. Sri

    I get same error reported by Bruce

    The tablix Tablix1′ has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.

    any help on this is appreciated…

  21. Himanshu Batavia

    After clicking on Advanced Mode, you have to select Static items on the left (row groups).

    Even if you see the same sort of “(Static)” things on the right (column groups) don’t change the settings there! Reporting Services will throw an error if you do.

  22. DeauxDad

    I am having difficulty with this. Column headers are not a problem with the Tablix, since they are in the Row Groups area. They seem to repeat happily on each page. I am not having any luck with Row headers, which would be in the column groups side. This specific tablix consists of N + 1 columns and 15 rows. The first column consists of static text. The N columns are the record results of the query – one column per record. When the tablix extends to the next page, I cannot make the first column display. I’ve tried setting the RepeatOnNewPage property for the Static Column Group Tablix Member, but that generates an error when the rdl is read into SSRS2008. Any help, short of transposing this thing, would be appreciated.

  23. JCrew

    Thank you for this post. Very helpful info. I have been beating my head on my desk for weeks trying to figure this out.

    Shame on Microsoft. Why have a non-functional “Repeat Row Headers” option in the intuitive place a user would think to look for it? Instead why not bury the option in a place that is not expanded by default and requires three properties to be set (KeepTogether, KeepWithGroup and RepeatOnNewPage ) once /if you can actually find the properties in the first place. Hope Microsoft makes this simplier in future versions. I would have never figured this out just poking around.

    Thanks again with the wonderful post and the useful info.

  24. kredyt bez zaswiadczen

    It is appropriate time to make some plans
    for the future and it’s time to be happy. I’ve read this post
    and if I could I desire to suggest
    you few interesting things or advice.
    Maybe you can write next articles referring to this article.
    I desire to read more things about it!

  25. facebook Security kaspersky

    Hi, I do think this is an excellent website. I stumbledupon it ;) I am going to revisit yet again since I saved as
    a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others.

  26. roll up lublin

    Thank you for the sensible critique. Me and my neighbor were just preparing to do a little research on this.
    We got a grab a book from our local library but I think I learned more clear from this post.
    I am very glad to see such fantastic info being shared freely out there.

  27. sean

    Having trouble getting this to work?? I get a ‘Tablix invalid’ error – all I want is to repeat the header columns in my report (its over 1000 pages long!!”) – I’ve been to Microsoft for help – they repeat what’s here, and again I get the same god damn errors!! Is this a serious bug in Report Builder 3.0 ?

  28. payroll service

    You can put on to get a job with a company who processes payroll
    for as much as several hundred clients or more, or in a company that
    processes it’s employee’s payroll in house. Additionally, the resource needs to generate arrangements for staff workout sessions, at the same time as make
    sure that all of the training material required is
    ready and in the end distributed amongst attendants. Just some
    clicks brings the list of best payroll processing companies.

  29. which credit report is best

    Some country laws give free files or reduced
    prices to the inhabitants. If there is any part of the report which is under consideration, you’ll possess a way to dispute or correct it.
    Sending correspondence while using individual’s name, social security number and current address is usually sufficient to request this free annual report.

  30. Rick Aarsvold

    I must tell you that it’s hard to find your articles in google, i found this one on 20 spot, you should build
    some quality backlinks in order to rank your webiste,
    i know how to help you, just type in google – k2 seo tips and tricks

  31. Margarito

    Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something.

    I think that you could do with a few pics to drive the message
    home a little bit, but other than that, this is wonderful blog.

    A fantastic read. I will certainly be back.

    my website – website (Margarito)

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>