Tablix headers not repeating in SSRS 2008
I have created a new report & add a table to it. When I select "Tablix Properties" and check on Columns Headers -> "Repeat Cheader columns on each page" the header columns do not repeat on each page. I also tried "Repeat header rows on each page". "Add page break before" seems to work ok. I am using VS 2008 9.0.30729.1 SP I also tried deploying butit stilldoes not work on the deployed version. Interestingly, reports migrated from 2005 & unchanged seem to be ok. Any ideas? Am I not setting soemthign up properly?
November 3rd, 2008 5:07am

Found it. It is a Tablix Member property rather than a property of the tablix itself. Steps: 1. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane) 2. Select the corresponding (Static) item in the row group hierarchy 3. In the properties grid, set RepeatOnNewPage to true
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 6:03am

mmm... Still having some problems. I want to be able to merge the row cells across the report for each of 2 groups in the report. But with the default group setup, this is not allowed. So I tried deleting the colums (without deleting the groups), added new columns with the filds & then merged them right. This works fine, but I lose the RepeatOnNewPage. And when I go thru all the static tablix members & add it, it still does not repeat the headings. Any advice? Thanks.
November 3rd, 2008 6:11am

On the data region as a whole, did you go to the tablix properties and set "repeat header rows on each page"?` -- Robert
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 8:18pm

Hi Robert, Thanks for the feedback. Yes I also tried setting this on. What seems to stop the column headers repeating is when I delete the first column on the report, even if I select the "Delete colmns only" option as I delete it. At the moment I am working around it by making this colmn invisible. But if you have any other ideas, I would appreciate hearing them. Thanks.
November 4th, 2008 12:48am

Hi, Dexter, The issue stems from the fact that there are elements in thetablix structure in a report definition that do not have a corresponding visual representation on the design surface. When you delete the column that was automatically added when you defined a row group, you are deleting the part of the tablix definition in the report that controls the rows that are associated with the row group, including the row that contains the column headings. There's a new BOL topic to help you understand how to help control repeating and freezing headers. Controlling Row and Column Headings: http://msdn.microsoft.com/en-us/library/cc281227.aspx HTH, Mary
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2008 9:05pm

Hi Mary, Thanks. From this article it seems possible to get the effect I am looking for without having to hide the group cols. I plan towork thru the steps on my next group report to see if I can avoid having to hide the group cols to get the head. I like the feature whichimports the "freeze panes" effect to excel- nice. regards, Dexter
November 12th, 2008 12:57am

Hi Mary,I know it's been a while since this post, but I am having the same issue. I have read the MSDN Article you have referenced. I would like to do just as the article mentions inTable with row groups and no row group area,however I need to repeat the full row of the current category if there would be a page break and all of the categories' orders did not fit on one page. In the article, this would be the Category "Accessories" and its Sales Total.When I set what the article suggests for the hierarchy item "(static)" below "(Category)" the data does not repeat. The article does it with the (static) above Category. This works. I would like the one below it to repeat too. I found a blog article that mentioned having to also set FixedData to True to include the group body in the repeat. When I do that, I get arsInvalidFixedDataInHierarchy Error. This is the BLOG article: http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspxwhich got me to try setting FixedData to True.I used to do this type of thing with MSRS 2005 day in and day out. I'm interested to hear if anybody can do it with MSRS 2008.
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2009 12:55am

The FixedData property has nothing to do with repeating rows on a new page. You only want to set the RepeatOnNewPage property.Assuming you already installed the latest cumulative update (CU#3 or SP1 CTP - see links here) for RS 2008, and if you still don't have it working, I'd encourage you to create a bug via http://connect.microsoft.com and attach a report that runs preferably on AdventureWorks data, and reproduces the problem you are describing. We'll then take a look and get back to you via connect.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
March 1st, 2009 12:51am

Emmanuel Vigneault (Thursday, May 07, 2009 11:22 PM) method is working for me. Steps: 1. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane) 2. Select the corresponding (Static) item in the row group hierarchy 3. In the properties grid, set RepeatOnNewPage to true Thanks for the contribution!
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2009 6:56am

1. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane) 2.Select the corresponding (Static) item in the row group hierarchy 3.In the properties grid, set RepeatOnNewPage to true4.KeepwithGroup to Afterkarthik-chennai
October 21st, 2009 7:01pm

Yep, that's it!! Thanks mrleokarthik !!
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2009 1:48pm

Regarding the KeepWithGroup=After setting: by default Report Builder / BIDS Report Designer would automatically and explicitly set the table headerKeepWithGroup property to After when you create a table with the table wizard, or simply create a new table on the design surface.I'm curious to hear from mrleokarthik and shiv179 how you got to the situation that the table header's tablix member KeepWithGroup was not automatically set for a table created in Report Builder. Do you have steps to reproduce this consistently?Thanks,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
October 30th, 2009 8:47pm

Hi Robert My reports were converted from 2005 to 2008. All my 2005 reports were always set to repeat the table header while scrolling. In 2008, the table header is treated like a normal row. Even setting the repeat options in the Tablix properties has no effect. After using the tip posted by mrleokarthik, it is working now. Hope this helps PS: I understand and appreciate the SSRS team's efforts to make 2008 more BI friendly, but some of the redesigns are actually quite painful for a developer!!! Some tasks are still quicker and easier in 2005!!! (toggling the table header, details and footer is one of them)
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2009 9:17am

Any update, SSRS team?
January 5th, 2010 6:12pm

Hi All,fyi. I still have issues with this occasionally & I find it's easier just to create a new table & paste the col headings & expressions from the old table into it & then setup the repeat headers etc again according to what is above.Cheers
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2010 2:48am

Hi,I am having the same issue, I want to show the table headers on each page but I have two groups in my table, SO I am unable to set KeepwithGroup to After property for both of them as it gives me an error.....but I did set In the properties grid, set RepeatOnNewPage to true for both the GROUPS.Still it is not showing me the headers on each page, It works If I use only one GROUP in my table, any idea what am I missing in this....???Thanks for your help.
March 5th, 2010 12:19am

This seems to be one of the biggest annoyances with SSRS 2008!! SSRS Team, please comment. Thanks
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2010 5:01pm

I am having this issue as well. I have followed all of the above mentioned guidelines and the rows will not repeat. They just show on the first page.KeepwithGroup = AfterRepeatOnNewPage = TrueFor each static row.
March 9th, 2010 11:24pm

This is the BIGGEST pain in the posterior to date with SSRS 2008. WHY on Earth Microsoft insists on making what was once the SIMPLEST of tasks into one of the most painful and quite honestly hit or miss tasks is simply beyond me!!! I still can't get column headers to repeat. In SSRS 2005, no problem!!! I am really starting to hate SSRS 2008. Everything I try to do has now somehow been made "better"...! I would really like to gear from the SSRS team on this one...A. M. Robinson
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2010 7:30am

SSRS Team???
March 11th, 2010 9:53am

1. I followed the detailed instructions concerning settings on the Static items in the RowGroup hierarchy, but it only worked for rendering to PDF and paging in the web, not rendering to Word. Word rendering is why we upgraded to SSRS2008!!!!! How can I get it to work in Word!!! 2. How can you add or delete a group header or footer on a group short of deleting and re-adding the group. I can't find any GUI or property settings for maintaining this. This was so easy in SSRS 2005!!!!!
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2010 10:53pm

I know i had the same issues with my report when we converted to SSRS 2008 last month.My reports would go to the next page and the header would disappear. So after doing some research on the boards, I found a post on the MS boards that UPDATE 5 to SP1 (update_5_SQL2008SP1_x86) fixed the issue in SSRS where the header was not repeating on certain reports.Once I had my IT Admin install this on the SSRS 2008 box, Bingo, the headers started to repeat on my reports.The BIG issue I had with SSRS 2008 was the Excel Margins where not keeping when exporting a report. That was huge because after we rolled out 2008, I had over 20 calls from users saying the page margins in the Excel export were wrong.MSConnect: Reporting Services 2008 Export To Excel Margins So after searching the boards and calling MS, they said its a known bug and will be fixed when R2 comes out..... Wish there was a hotfix for this!!!
March 11th, 2010 11:55pm

I know i had the same issues with my report when we converted to SSRS 2008 last month.My reports would go to the next page and the header would disappear. So after doing some research on the boards, I found a post on the MS boards that UPDATE 5 to SP1 (update_5_SQL2008SP1_x86) fixed the issue in SSRS where the header was not repeating on certain reports.Once I had my IT Admin install this on the SSRS 2008 box, Bingo, the headers started to repeat on my reports. I think SSRS_DEV was actually referring to Update Package 6 which fixes a slightly different Row header bug. You want Update Package 7 (released 2 days ago) which FINALLY fixes the Tablix Header Not Repeating bug! Note that this is a CUMULATIVE update package which means it also contains all previous hotfixes since SP1. Hope this helps!
Free Windows Admin Tool Kit Click here and download it now
March 18th, 2010 4:10am

Hi 619 I think the ONLY way to fix this is to go back to the way SSRS 2005 did things ;-) Regards, Shiv
March 29th, 2010 12:08pm

619, Mary, Robert, I installed update 7 but this still does not work for the export to Word. I've followed all of the instructions as to Matrix Repeat Column Headers, and Tablix Row Groups Advanced Mode Fixed Data, Repeat on New Page, and Keep Together settings. Could someone provide me with a sample RDL that works with the Word rendering. This is an obstacle for our use of SSRS 2008 as we wanted the Word rendering.
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2010 10:20am

Most of the issues with Repeating Table Headers in Word seems to be an issue with how SSRS renders to Word. SSRS renders vitually all objects as Tables in Word including the text boxes, rectangles, tablixes, lists, and I think even the report body. Any nested tables in Word will not repeat the table headers for the inner tables. Since everything renders as a table in Word, nested tables are virtually impossible to avoid, and the table headers will not repeat no matter how well they have been defined in SSRS.
April 8th, 2010 1:33am

It doesn't work for me. I have multiple layers of grouping and my static header is at the very top of the tablix. I really regret switching over to SQL 2008. It's so unstable.
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2010 1:16am

It does not work for me either. I have done all of these settings, including creating a whole brand new report and I still cannot get the row header to repeat, nevermind have the row header freeze on excel export.
May 20th, 2010 8:42pm

No resolution here either. Tablix Headers don't show on last page of PDF and TIFF output. I've tried all things mentioned including installing SQL Server 2008 Cumulative Update# 7. My issue is that I have a Tablix with some header rows that repeat fine until the last page. On the last page they are hidden. This appears to be true of PDF and TIFF output. THere are other issues with Word output. The standard HTML viewer works fine. So its clearly a PDF renderer issue. Microsoft, if you are listening, please help!!!
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2010 8:30pm

Yes, this is still a problem for me too. I have a simple table and merely want to repeat the column headers and cannot. I created the same report on a machine with SSRS2005 and it works perfectly and very easily. I have tried all the things mentioned here and in other articles and NOTHING works. I can't fathom the thought process that took place at MSFT to make something that had been working great in 2005 so much worse in 2008. I suspect no thought at all and very little testing. Seriously? I thought the idea was to make report development easier, at least that was the marketing hype spewed out of Redmond when SSRS 2008 was released.will
May 25th, 2010 12:56am

Hey everyone, I opened a MS CONNECT dealing with this, I would hope you all would vote on this and offer your input "Excel Export create freeze pane on Tablix Header Row not page header Row" https://connect.microsoft.com/SQLServer/feedback/details/561128/excel-export-create-freeze-pane-on-tablix-header-row-not-page-header-row
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2010 6:19pm

This article worked for me: http://blog.bignickolson.com/2009/03/11/repeating-tablix-headers-in-ssrs-2008/
June 9th, 2010 5:18pm

Hello SSRS Team.. Please help, I am unable to repeat the columns in a table, I tried all this RepeatonNewpage =True / Keepwith Group = After. Actually I dont know which static to be changes, there are so many statics( I have 6 groups) Plss helpppppppppppppppppppppppppppp Thanks
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2010 11:02pm

Hi there, I know this is an old forum post however I am having the same problem and realise it is probably because I have deleted the column associated with the group as detailed by Mary in the answer. Is there a way to recify my mistake without redoing the whole report layout? Many Thanks, Katie
June 16th, 2010 5:59pm

I have now battled with this for a few days and just think it is not acceptable how Microsoft can take such a huge step back with something that is so fundamental and simple in reports!!! I have 2 row groups: StatusGroup (group 1), and ApplicationID (group 2) So the advance group properties looks like this: Static * Static * (Static) * [StatusGroupTo Static * (Static) * ApplicationID Static * * I have set the KeepWithGroup propery and the RepeatOnNewPage property on all of these areas to After and True respectively in all possible combinations, but NOTHING works!! I must just add that the columns created for the two groups are hidden.
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2010 12:48pm

I have a related problem. I have a report with a details group; group3; group2; and, group1. They are all nested. The group headers have data that is useful for the report. The details visibility is determined by an expression. So, it is possible that details will not display for all groups. When that happens the group3 header still displays --- good thing. However, the group2 and group1 headers do not display --- bad thing. I checked the advanced mode properties for all groups and the RepeatOnNewPage and KeepWithGroup properties are as you recommend above. I have tried various combinations on teh details_group with no change in the results.Leo
October 29th, 2010 11:57am

Table header repeat issue: instruction listed here works. this thing is, why SSRS makes such common report feature so 'mystic'.
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2010 10:49am

I, too, was bitten by this challenge but the instructions listed here helped solve the issue. I'm not pleased that the solution isn't intuitive but now I know. I'm now left to hunt to figure out how to make those column headers scroll when the user scrolls down the page. My other reports (which don't contain grouping) use this functionality and the clients are quite happy with it. Finally, I can't agree with the poster that responded they didn't like SSRS2008 because I think it is a major upgrade over SSRS2005. Try implementing a column group on a table in 2005 and you'll see what I mean. You can't -- you have to use the matrix. Now, try to have multiple row groups that correlate to that column group. One record per line that will have one-to-many items in the column group. Now tell me how you get your row groups to have their own column headers. You can't. I've had to hack a solution together involving a table with no data (just column headers) and superimpose that over the matrix where I needed the row column headers. And that still doesn't work because when you deploy it to the server and view it through a browser (IE 8 I might add!), the hacked column headers don't float correctly. It's a real visual treat that you can't fix. I spent hours and you just can't fix it. But go to SSRS2008 and the new tablix object allows you to handle this quite nicely. In fact, it's easy. Then there are the upgrades to the matrix object. Overall, I like SSRS2008 but these group column headers are a pain because they aren't intuitive and I'm not even sure if the scroll feature is available. Yet...
March 3rd, 2011 5:17pm

Please review the post below which talks about same issue http://gauravsqlserver.blogspot.com/2011/03/repeat-tablix-row-header-on-each-page.htmlThanks, Gaurav http://gauravsqlserver.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 3:35pm

Please review the post below which talks about same issue http://gauravsqlserver.blogspot.com/2011/03/repeat-tablix-row-header-on-each-page.htmlThanks, Gaurav http://gauravsqlserver.blogspot.com
March 23rd, 2011 3:35pm

mrleokarthik If I do this why does it leave alternate pages blank?Regards Partha Mandayam IT Consultant Invacare http://weblogs.asp.net/pmandayam http://partha.tripod.com
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 10:56am

I do not think this has to do with the settings used for repeating the page header. The blank page usally comes when there are blank spaces left between the header/footer and the body of the report. Try removing all the empty spaces and see if that works.Thanks, Gaurav http://gauravsqlserver.blogspot.com
March 29th, 2011 11:07am

Does anyone know how to read this Advanced mode? When I look at it I have under Row Groups Static Static grpProgram (first group level) Static Static grpTask (second group level) Static X 4 grpItemtype (third group level) Details Group STatic Static so on ... How do I know which one is the row with the headings that I want to mark with the repeat. Depending on the level where I try to find where to set these properties, I will get an error about them. Man ... so much more confusing trying to work with these groups than in 2005 or even 2000! Any help would be appreciated.Sherry
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 5:34pm

Same problem here - tablix headers are missing on the last page (sometimes two pages) of PDF output. On SQL 2008 R2 CU7.
June 20th, 2011 5:45pm

Found it. It is a Tablix Member property rather than a property of the tablix itself. Steps: 1. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane) 2. Select the corresponding (Static) item in the row group hierarchy 3. In the properties grid, set RepeatOnNewPage to true Great. This worked for me too. Thanks for the tip/ solution.
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 1:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics