Repeating Headers
Hi, I am working with the latest CTP and having trouble with repeating headers when dragging a table (tablix) object onto thedesignsurface. Enabling the repeating option in the Tablix Properties does not actually repeat my headers. On the other hand, when dragging the Matrix object onto the surface, it does. Are there any known issues here? Ron
December 31st, 2007 2:32pm

I am seeing some inconsistancies with how items repeat or do not repeat when in normal display mode or in Page Display. When I associate a Rectangle with a List this occurrs. In normal preview mode the rectangle "header" repeats fine. In Page preview mode it displays once and does not repeat on each page. I use a Table instead of a tablix and it repeats on each page fine if the checkbox is checked (rdl code:<RepeatOnNewPage>true</RepeatOnNewPage>). It is maddening how inconsistant how the header footer and separate parts interact between the regular preview and the page preview. Are you seeing this problem too?
Free Windows Admin Tool Kit Click here and download it now
January 11th, 2008 10:55pm

It appears that you're setting the property at the wrong scope. I'm not an expert in this area of the product but you need to set RepeatOnNewPage on the innermost static row member, not on the column headers. We working on a usability fix, but you won't see that until later in the release. Hope that helps, -Lukasz
February 13th, 2008 9:48pm

Hi, can you please include your RDL file so I can take a look? You can just include the Tablix part. There will always be some inconsistencies between regular preview and print preview, we try as best as we can to minimize them. -Chris
Free Windows Admin Tool Kit Click here and download it now
February 13th, 2008 10:58pm

Ron Torrico, CodeWulf: Haven't heard from either of you on this thread for quite some time. Please file bugs in http://connect.microsoft.com with additional details so we can determine if there is a product bug at the root cause of your issue. Thanks, -Lukasz
March 3rd, 2008 9:18pm

My rdl is more than 5000 characters so I could not post it. I am usingone Rectangle andone List. The Rectangle is set to repeat with the List. it views correctly when not in "Page Layout". It does not repeat the Rectangle if in "Page Layout" mode. The repeating list is only 3in. high and repeats many times to fill two pages of report. Alert does not send the email to my normal email, so I do not check this forum as often as I would like. I appriceate your help.
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2008 12:54am

Please file an item via http://connect.microsoft.com and attach the report as an RDL file to that issue. -- Robert
March 6th, 2008 12:08am

Hi,I had the same problem after drag/drop of a table onto the designer. I could not get the the column headers to repeat. I'm so glad found this thread which led me to adding the <RepeatOnNewPage>true</RepeatOnNewPage> directly into the .rdl. I was concerned that there wouldn't be a fix before we go into production with my app. I could not find a way to do it via any of the properties boxes, either through the tablix or the details group properties. Incidentally, when I create the table via the Report Wizard, it does not exhibit this problem. I'm using the2008 RTM with VS 2008 SP1.Thanks,Al
Free Windows Admin Tool Kit Click here and download it now
September 10th, 2008 7:55pm

You can do this also in report designer / report builder. Unfortunately it is a bit complicated if you have a table layout (not a matrix layout): 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 Hope this helps, Robert
September 10th, 2008 11:26pm

Robert,That was EXTREMELY helpful!. Don't know how that little down arrow escaped me before. Much easier now that I know about the advanced mode. I'm really enjoying working with SSRS 2008; it's a beautiful product.Thanks,Al
Free Windows Admin Tool Kit Click here and download it now
September 12th, 2008 4:33pm

Thanks for the feedback. Btw, I also transformed the instructions into a blog posting: http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx -- Robert
October 15th, 2008 8:18am

Can you do anything about this in Reporting Services 2005 SP2. I can't get headers to display on each pageafter anExcel Exporteven with settings as you stated above. In the body I have a list surrounding a table. I want the table header to be repeated on each page when printed from Exel Export. Thanks. John.
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2008 3:17pm

Have you ever found a case where none of this actually got the header to repeat on new pages? I have the header repeating as you scroll down a single page, but it never repeats on new pages. I've successfully got both working on other repeats and just can't figure out what could be wrong.Byzet, LLC
February 11th, 2009 4:54pm

Check out this link to repeat column header in SSRS 2008http://support.microsoft.com/kb/955822Thanks,Tushar
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2009 1:27pm

Tushar's advice didn't help me; I didn't upgrade the reports from SSRS 2005, and the headers do repeat as a scroll down the page; just not on new pages. SSRS 2008 is a nice improvement over 2005 but it seems to have a lot of bugs when it comes to headers. I kinda solved my problem by not using a table header but by creating a new group (on a constant value of 1) and using group headers. That works sometimes - although sometimes (when the first actual row on the page is not a detail row, but another group header) it won't work.I even found one scenario where it worked perfectly on screen, but when I printed it the headers weren't repeated on each page!It's quite frustrating when a client asks for something as simple as headers on each page and you have to spend hours just to get it kinda working... this seems to be one of those cases where the product is so flexible and has so many options that you wind up being unable to easily do things that should be very, very simple.Byzet, LLC
March 13th, 2009 3:17pm

I fought this for days. Try this. Create a simple report using the Wizard that has repeating headers. compare it to one without paying attention to the arrangement of the static rows under the advanced tab of the groups. It somehow sets up the structure differently that when you build one from scratch. I have it repeating headers on each page like before in 2005, but I still can't get the headers to scroll unless they are part of the outermost grouping which is not what I want.
Free Windows Admin Tool Kit Click here and download it now
March 17th, 2009 9:10am

Hello Ron,did you try to install Cumulative Update #4 for RS 2008:http://support.microsoft.com/kb/963036/en-us? If the problem still persists afterwards (and you verified you the RDL properties for repeating headers are set correctly based onhttp://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx) , I'd suggest to build a small repro report based of AdventureWorks data and submit a bug via http://connect.microsoft.com Thanks,Robert Robert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
March 17th, 2009 9:46pm

I struggled with this for hours before stumbling upon this thread, trying different things. Thankfully, I have my column headers now repeating on each page. The procedure to get this to work is not intuitive at all. It would really seem that use of the "Repeat column headers on each page" option on the tablix properties should take care of this and you wouldn't have to do anything more.
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2010 4:34pm

I have recently been struggling with this issue and had tried several settings and suggestions I found on the internet to no avail. The particular reports that I was working on had been upgraded from SSRS 2005 to 2008 (I'm not sure if the upgrade caused the issue or not). After I turned on advanced mode to adjust the properties for my groups I noticed that my (Static) rows listed in the Row Groups section did not match up with the rows in my tablix. I had extra (Static) rows and they were sometimes indented without a group. When this phenomenon occurs I found that no matter what I had set in the properties it did not seem to change how the report rendered. In order to resolve the issue I had to remove the invalid entries from the TablixRowHierarchy section of the rdl itself manually. After correcting the rdl the property settings took affect and my headers repeated on new pages correctly.
June 29th, 2011 1:24pm

First entry on this is 2007 last entry 2011... sounds like a long time to have a problem. Thanks for the string of solutions... just another IT guy trying to get reports completed for end users. My solution on upgrading reports from 2005 to 2008. Keep everything in report but the table. Blow it away and add another table. Go to tablix properties and connect to dataset name. DO NOT mess with the check boxes below. Create ONE parent group with header and footer.... for this test. It creates a column with the group field which I don't like cause it wastes real estate BUT don't delete it or repeating headers won't work. Remove the expression and header from this column and make as small as possible. Now continue building your columns of detail. When finishied, go to the center bottom pane and to the right of Column Groups there is a down arrow, check Advance Mode and two static rows appear above your group and one below. Click on the TOP static row and in the properties window set RepeatOnNewPage = True. This creates the code <RepeatOnNewPage>true</RepeatOnNewPage> If you go to the other Static lines and set this property to True it will also create this code in places that won't help. That's why it is so hard to make the entry manually. For me the jury is still out as to whether 2008 is better than 2005 especially when a half day is wasted on this. MS still has a long way to go to catch up with Crystal. Thank goodness many of our users are starting to use excel pivot tables and we generate non formatted columns of data for their use. Thanks Matt at Aspen Ski Co
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 7:06pm

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

Other recent topics Other recent topics