SSRS 2008 Export to Microsoft Word does not include headers and footers

Sophia picture Sophia · Feb 6, 2009 · Viewed 9.6k times · Source

I have a report, which was recently converted from SSRS2005 to SSRS2208.

The report header has a background, which is calculated depending on the page number. In the report footer there is an image and two text boxes, also calculated depending on page number.

The report preview in the Business Intelligence Development Studio displays correctly, exporting to PDF also works correctly. However, when exporting to Microsoft Word the header and footers disappear and page margins increase by about 1.5cm.


The margins part of this issue has been reported in Microsoft Connect and resolved. The fix should be "in SqlServer2008R2 CTP3 and beyond".

Answer

MartinHN picture MartinHN · Feb 7, 2009

I'm not sure how to do it, but I might have an idea. In SSRS 2005, with export to Excel you had to change the Excel Device Information Settings in the config file of SSRS to use SimplePageHeaders: http://msdn.microsoft.com/en-us/library/ms155069(SQL.90).aspx (How to: http://mysqlserverblog.com/2008/01/03/changing-export-options-for-reporting-services.aspx)

I looked up the Word Device Information Settings, but as far as I can tell, there no such setting: http://msdn.microsoft.com/en-us/library/cc281123.aspx

But good luck!