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