Hello,I had the same problem as others where the tablix header will not repeat on multiple pages of the report. I followed the instructions here http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx and it did not solve the problem. After trying several scenarios, I found that it was not repeating because I have each header value in a rectangle which spans one column, rather than having each header value in it's own tablix column.For instance, if we have fields CompanyID and CompanyName on the report, the repeating headers work if I have them in separate columns like this: Tablix Column 1 | Tablix Column 2Tablix Header row Company ID | CompanyNameTablix Detail row [CompanyID] | [CompanyName]It DOES NOT work when it is designed like this: Tablix Column 1Tablix Header Row Company ID Company Name (two textboxes in a rectangle)Tablix Detail Row [CompanyID] [CompanyName] (two textboxes in a rectangle)Additional infoWe have about 1000 reports designed this way that we originally designed in Reporting Services 2005. We upgraded to 2008 and the reports are displayed just fine except for this issue with the header repeating on multiple pages. Is there any way to resolve this WITHOUT having to redesign all of these reports?Thank you,Reyna

I'm confused...I am seeing the exact opposite. I have a simple table with multiple columns. Each header is in its own column. I cannot get column headers to repeat, and I have tried EVERYTHING!!!A. M. Robinson

I'm confused...I am seeing the exact opposite. I have a simple table with multiple columns. Each header is in its own column. I cannot get column headers to repeat, and I have tried EVERYTHING!!! A. M. Robinson Hi,CHeck this link http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspxI hope this link Might Helpful for youRajesh Jonnalagadda http://www.ggktech.com

I tried this exact same method and got nothing but errors telling me that the settings for the column groups were incorrect... I'm using a table style layout, and the steps here outlined do not work. I have set every member of the column "group" to the settings mentioned and still cannot get headers to repeat. I get this error when I try to set the repeat on page true: [rsInvalidRepeatOnNewPageOnColumnTablixMember] The tablix 'Tablix2' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false. [rsInvalidFixedHeaderOnOppositeHierarchy] The tablix 'Tablix2' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedColumnHeaders of tablix. This is ridiculous. Now I'm forced to use SSRS 2005 to create my reports. At least that way I know they'll work. I would love to hear from someone at Microsoft why they chose to completely muck up this most simple of functionality. I have SEVERAL friends in the "industry" who are miffed - to say the least - about this "functionality". A. M. Robinson

Hi,try this--Step 1Open Tablix Properties and uncheck the Checkboxes related to Row Headers section and Column Headers section-- Step 2Follow the steps in linkhttp://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspxRajesh Jonnalagadda http://www.ggktech.com

This may or may not be relevant: FIX: Header rows of a tablix do not always appear at the top of pages in an SSRS 2008 report http://support.microsoft.com/kb/980949/

Hi, I ran into the same error, got a solution with some thinking. Try this, strep 1: Rt. click on tablix and go to properties, or select tablix and press F4. step 2: Locate "Fixed Column Headers" and "Fixed Row Headers". Step 3: Set both the values to TRUE. Step 4: Now retry the steps to repeat the header on each page. MARK as ans if it solves ur purpose

I had the same problem. what helped me was: In the Tablix properties check the boxes for: Repeat header rows on each page and Keep header visible while scrolling. make sure that the column headrs check boxes are NOT checked. In the Group pane on the left (Row Groups) the first line is static. set its: "ReapetOnNewPage" property to TRUE set its: "FixedData" property to TRUE set its: "KeepWithGroup" property to AFTER I hope you find this info helpfull.

Hi Kirill, the key step was n.2, it made the solution successful to me. Thanks

This works for me. To summarise: Uncheck all 4 boxes in the Tablix Properties - General page. Then follow the steps in the link.

It worked for me too..Thanks for the solution

I followed the instructions exactly as outlined and when I click the first Static cell in the Row Groups pane, first of all, nothing highlights on the tablix, and second, when I try to build I see this error: Error 1 [rsFixedHeadersInInnerDataRegion] The tablix ‘table1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions. Stan

I had the same problem. what helped me was: In the Tablix properties check the boxes for: Repeat header rows on each page and Keep header visible while scrolling. make sure that the column headrs check boxes are NOT checked. In the Group pane on the left (Row Groups) the first line is static. set its: "ReapetOnNewPage" property to TRUE set its: "FixedData" property to TRUE set its: "KeepWithGroup" property to AFTER I hope you find this info helpfull. Unfortunatly, all these suggestions don't work. I am able to repeat (not always!) the headers on every page but can't make the header row scroll.Stan

Just Select the column or row you want to repeat by clicking on the header cell.. in the property tab look for REPEAT WITH set it from none to the tablix name...it worked for me..hope it will solve your problem

Stan, You have to follow the steps only on the static cells that are before the highlighted row in the Row Groups panel.

Stan, set the KeepTogether property to "TRUE" . I hope it helps you. for me it works just great.

The Advanced Group guidance found here and on other blogs works ... most of the time. The exception I've found is when you have columns that can be populate with strings with 1,000s of characters and the page break occurrs in the middle of a row or string. In that case, you'll notice that, on those particular pages, the header row will not appear. To test whether or not this is your particular issue, you can simply change the expression on the column that has the lengthy strings to LEFT(<column>,200) and see if you still have the issue.

I have a similar problem, I just want to make a repetition of the column headers in a tablix. I unchecked all the general options on the tablix level. I set the static properties to FixedData=true, KeepWithGroup=after, RepeatOnNewPage=True. And I've got now the following error (I translate from French): Unvalid TablixMember. The KeepWithGroup property of all the TablixMember elements in a TablixColumnHierarchy must have the "None" value. I have another question: is it also possible to repeat the column headers after page breaks for tablix without static part ? The head of my columns are month names dynamically generated. This is another tablix than the one with the previous problem. Thanks