February 9, 2017 at 11:38 am
Hi
I am extracting an excel file from SSRS report and need to freeze headers when exported to excel.
tried to separate headers in to header of ssrs and mapped to columns.
when exported to excel there are merged columns after every column.
data gets separaetd when headers moved.
the columns shown in excel are A C E.. hidden or merged columns are B D F..
is their any other way to achieve this.
approach followed:
https://www.mssqltips.com/sqlservertip/3548/freeze-excel-column-header-for-sql-server-reporting-services-report/
February 13, 2017 at 4:19 pm
vinithreddy081 - Thursday, February 9, 2017 11:38 AMHi
I am extracting an excel file from SSRS report and need to freeze headers when exported to excel.
tried to separate headers in to header of ssrs and mapped to columns.
when exported to excel there are merged columns after every column.
data gets separaetd when headers moved.
the columns shown in excel are A C E.. hidden or merged columns are B D F..
is their any other way to achieve this.approach followed:
https://www.mssqltips.com/sqlservertip/3548/freeze-excel-column-header-for-sql-server-reporting-services-report/
That is the only workaround I've ever seen for this issue. You have to be pretty careful to not end up with the merged columns, I always ended up with those. But I worked with someone else who did get it working. Kind of bad that this is still an issue.
Sue
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply