Freeze report column headers while exporting report to excel

• kirtiM

  Old Hand

  Points: 326

  More actions

  February 13, 2014 at 1:33 am

  #304141

  Hi,

  I am using ssrs 2012 and exporting my report to excel. Page header in the report is freezed but the column headers are not and hence while scrolling down, the column headers goes up.

  Is there any way to achieve freezing of column headers as well in excel?

  Can we do this via custom code or say exporting data in an macro enabled excel? or tweaking through the rendering extention?

• $t@r

  SSCommitted

  Points: 1751

  More actions

  March 19, 2015 at 4:21 am

  #1784997

  Hi,

  Did u get any solution for this??..even i want the same..

  Thanks

  Swat

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  March 26, 2015 at 1:19 pm

  #1786668

  I found the following 2 articles. You are not the only person that wants this feature. There are work arounds for the issue:

  https://connect.microsoft.com/SQLServer/feedback/details/561128/excel-export-create-freeze-pane-on-tablix-header-row-not-page-header-row

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/acd030c4-6502-46c5-89f7-9101b73b31db/how-to-freeze-the-columns-in-excel-exported-from-ssrs-report

• Black_T

  SSC Veteran

  Points: 259

  More actions

  March 30, 2015 at 9:24 pm

  #1787546

  Hi kirtim,

  This is the limitation when exporting to Excel. It's not supported to have the column header fixed while scrolling in Excel. Because after exporting to excel, the whole report area is cell based, it just hide the border of each small cells in Excel. That's not a real row in Excel. For more info, please see:

  https://msdn.microsoft.com/en-us/library/dd255234.aspx#PageHeadersFooters