Hi i had developed a report in which if i export to EXCEL only the Header portion is Freeze when i scoll down.. But my requirement is to Freeze the Column header along with Report Header.. I try doing this way by adding Column headers to Header the Format is Food Report is Breaking up.. So is there any option in SSRS 2008 to freeze the Column header along with Header when we export to Excel..

Did you set the FixedData property to True? Please go through the following article - http://msdn.microsoft.com/en-us/library/bb934257(v=sql.100).aspx

Hi, Steps to achieve it 1. Select the tabix and click on Tablix properties. 2. In the General tab under Column Headers section you can see "Keep header visible while scrolling" checkbox, check it. 3. Now the header row will be remain fixed in the report. Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.

Hi Vani23, From your description, you need to freeze column header and report header when export the report to Excel. By default, the report header will be freezed automatically when export the report to Excel. Currently, if the report is exported to Excel, the column header will not visible when scrolling down. Since this behavior is by design, it is my pleasure to help you to reflect this situation to the proper department. You can also submit feedback at https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided. We appreciate for your understanding. Thanks, Bin Long