Geek Answers Handbook

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

I have a report that has recently been converted from SSRS2005 to SSRS2208.

The title of the report has a background, which is calculated depending on the page number. The report footer has an image and two text fields, also calculated depending on the page number.

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

Some of the fields of this problem are reported in Microsoft Connect and resolved. The fix should be "in SqlServer2008R2 CTP3 and higher."

+4
source share
3 answers

From some experiments, it seems that the export function in Word Document does not work if

  • Header or footer elements have properties that are calculated based on the page number.
  • Headers and footers have background images.

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

There are probably more situations where headers and footers are not exported to Microsoft Word than the ones I have listed. As far as I know, there is no way to get more complex headers and footers for working with export to the Word Document function.

+1
source

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

I was looking for parameters for information about the Word device, but, as far as I can tell, there is no such setting: http://msdn.microsoft.com/en-us/library/cc281123.aspx p>

But good luck!

+2
source

I have a report where the header and footer are exported correctly, however, on the first page, Word interprets the footer, which will be different and for some reason hides it. There seems to be a slight difference in height between the first and the rest of the pages.

If you are editing a footer, this is a check box in Word 2007 and 2010 that allows you to show it anyway. I don’t know why SSRS exports it differently between the first and other pages.

0
source

More articles:


All Articles