So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file. The tablix is right at the top of the body and spans the entire width of the design area. How in the world do you get it to freeze in the Excel export file?

Rashiki777, From your information, I get that you want to freeze the tablix header when view the report in Excel. Please follows these steps: Click the header row Click View menu on top of the toolbar, then you will Freeze Panes Select one kind of Freeze based on your requirement. This link supplies the detailed steps http://inpics.net/tutorials/excel2007/vis5.html If you have any concern, please feel free to ask. Of course, you could utilize the list control to display a certain rows on one sheet, then every sheet in Excel will have one header, the steps are following: Drag a list into report body, right-click Details in Row Groups panel to select Group Properties…. Click Add button, then type in expression =ceiling(RowNumber(nothing)/25) in the textbox Note: 25 is just 25 rows per page, you could reset this value based on your requirement. Drag the table control into this list control. If you want to display every page in every sheet, you could add a page break to the table control in the list. Best regards, Challen Fu

Hi Rashiki, You stated that "I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 ", can you share your knowledge with us? THanks.

Nirvana, To repeat headers from a tablix in any export format simply highlight the tablix control and set "repeatcolumnheaders" property to true. Hope this helps! Thanks Dave