CODEWITHSUNDEEP
excelreporting-servicesssrs-2008export-to-excelssrs-2008-r2
user3114677
user3114677

Reputation: 9

SSRS Export to Excel freeze header row not working

I have reports in SSRS 2008 R2 with freeze header row but when export to excel the header not freeze. How can I do this?

Upvotes: 1

Views: 1652

Answers (1)

R. Richards
R. Richards

Reputation: 25151

Unfortunately, that feature works with HTML rendering only. The freeze header row feature will not export to Excel.

The only way freezing a row works with exporting to Excel is when there is a page header as a part of the RDL (the header freezes at the top of each sheet). But, the results aren't what you probably want since the column headers usually are not in the header section of the report.

Upvotes: 1

Related Questions