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

Question

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 1

From some experimenting, it seems that the export to Word Document feature doesn't work if

• header or footer items have properties that are calculated depending on the page number
• headers and footers have background images

Simplifying the header and footer contents should make them to appear.

There are probably more situations where the headers and footers don't export to Microsoft Word, than the two I've listed. As far as I'm aware there isn't a way to get more complex headers and footers to work with the export to Word Document feature.