Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS 2005 - Exporting of report header to Excel

Author  Topic 

bigweed
Starting Member

19 Posts

Posted - 2010-12-02 : 07:31:33
I have a simple report setup in SSRS 2005. It has both a report header and report footer. When I preview the report in SSRS 2005, the report header and report footer print on every page. When I export the report to Excel, the report in Excel does not contain a page header or footer. I have checked this in the Print Preview. So the report header only prints on the first page, but no other pages. And the report footer doesnt print at all in Excel.

I have been reading about this issue for hours, and it seems that SSRS report footers cannot be exported to Excel to display as page footers, ie on every page. However, I cant seem to find an answer about how to make the report header from SSRS 2005 show up as a page header in Excel, ie show up on every page. Can someone please help with this question?

We are running VS2005, Excel 2007.
   

- Advertisement -