How to freeze the columns in excel exported from SSRS report??
We have created a report for our client. The client wants the report in excel format. As there are nearly about 30,000 rows in the excel. Client wants us to freeze the column header names in the excel so that even after scrolling down they will be able to see the column names. can anybody have idea how to achieve this in SSRS?
April 5th, 2012 6:25am

I think the only way you are going to achieve this is if you put the table headers into the page header this will work but is not ideal. for more info see the thread below: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/dc409765-a88f-4616-9242-15d2645d1305/
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2012 6:59am

Hi, Set the FixedColumnHeader to True. This will freeze the header row in the excel export of your SSRS reportBunch of thanks ~ Deva ~ mark it as answer if it answered your question :)
April 5th, 2012 7:13am

Hello, Follow the thread below. It will help you on this. http://msdn.microsoft.com/en-us/library/ee240753.aspx
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2012 7:23am

Hi Shard, Thanks for your post, You can achive your requiremets by using the below logic. hope this will help you. 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. OR 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 4. KeepwithGroup to After OR 1)Freeze the header of all columns[ Freezing table header ] : To do select static member of table header row from row groups [ Advanced Mode ] and set FixedData to true 2) Freeze the initial 2 columns : To do select static member of columns in column group and set fixedData to true . How do you freeze the tablix header row in an Excel export file in SSRS 2008 Suhas KudekarMark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful. My Blog Follow @SuhasKudekar
April 5th, 2012 8:58am

I tried all this ways, but no ones help. By the red color on screenshot, I marked the area, wich should be freezed.
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2012 12:30pm

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

Other recent topics Other recent topics