Hello All,

My Greetings for the day!!!

I am trying to freeze the header column of tablix on export to excel in my SSRS report developed in 2012. So when user scroll down in the report the header and the 1st column in the tablix is freezed.

Please revert with your valuable suggestion.

Regards,

Hiren

Hi Hiren,

In a table, if we want to freeze column header, we should make the changes in the first Static row group in Row Groups pane with Advanced Mode as you said. If we want to freeze row header, the table should have a group ahead, then we can enable Repeat header rows on each page and Keep header visible while scrolling options in Row Headers in Tablix Properties dialog box.

In a matrix, if we want to freeze column header, we can enable Repeat header columns on each page and Keep header visible while scrolling options in Column Headers in Tablix Properties dialog box. If we want to freeze row header, we can enable Repeat header rows on each page and Keep header visible while scrolling options in Row Headers in Tablix Properties dialog box.

http://msdn.microsoft.com/en-us/library/bb934257.aspx

Hello Milan Das,

Thanks for your suggestion.

I truly appreciate for the precious time you have given for my question.

I have tried your suggestion in my solution. It works in the preview of the report.

However, when I export the report to excel. In excel the 1st rows are not freezed which is I am trying to achieve.

Please revert.

Regards,

Hiren Parikh

Hi Hiren,

Try the  following:

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 

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

Hello Milan Das,

My Greetings for the day!!!

I have tried the different suggestion given by you above.

The report freeze the headers while viewing in SSRS Preview or Share point.

However, When I export the report to Excel. While scrolling the report in excel the headers are not freezed.

Can you please suggest me.

Regards,

Hiren Parikh