I have the header in my report on SSRS frozen so it scrolls down as I scroll down the page. Is it possible to keep this header frozen when I export the report to excel so it will do the same in excel?
A:
As far as I know, you can't do so with table headings. However, items that appear in the Page Header section of a report do get exported to frozen heading rows in Excel.
Mark Bannister
2010-08-05 10:52:01
In my experience the only thing SSRS Excel export uses Freeze Panes for is for the PageHeader and only when SimpleHeaders=false (the default). Excel export ignores the FixedHeaders property.
u07ch
2010-08-05 10:55:17