我有一份报告，最近从 SSRS2005 转换为 SSRS2208。
报表页眉有背景，根据页码计算。 报告页脚中有一个图像和两个文本框，也是根据页码计算的。
Business Intelligence Development Studio 中的报告预览可以正确显示，导出为 PDF 也可以正常工作。 但是，导出到 Microsoft Word 时，页眉和页脚消失，页边距增加约 1.5 厘米。
此问题的边距部分已在 Microsoft Connect 中报告并得到解决。 修复应该是“在 SqlServer2008R2 CTP3 及更高版本中”。
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".
发布评论
评论（3）
我不知道该怎么做，但我可能有一个想法。 在 SSRS 2005 中，导出到 Excel 时，您必须更改 SSRS 配置文件中的 Excel 设备信息设置才能使用 SimplePageHeaders：http://msdn.microsoft.com/en-us/library/ms155069(SQL.90).aspx （如何：http://mysqlserverblog.com/2008/01/03/ Changeing-export-options-for-reporting-services.aspx）
我查找了Word设备信息设置，但据我所知，没有这样的设置：http://msdn.microsoft.com/en-us/library/cc281123.aspx
但祝你好运！
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!
导出到 Word 文档功能似乎不起作用
简化页眉和页脚内容应该使它们
页眉和页脚不导出到 Microsoft Word 的情况可能比我列出的两种情况更多。 据我所知，没有办法让更复杂的页眉和页脚与导出到 Word 文档功能一起使用。
From some experimenting, it seems that the export to Word Document feature doesn't work if
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.
我有一份报告，其中页眉和页脚已正确导出，但是在第一页上，Word 将页脚解释为不同的并且由于某种原因隐藏了它。 第一页和其余页面之间似乎有一点高度差异。
如果您编辑页脚，Word 2007 和 2010 中会有一个复选框，允许您无论如何显示它。 不知道为什么 SSRS 在第一页和其他页面之间导出不同。
I have a report where the header and footer is exported correctly however on the first page Word interprets the footer to be different and for some reason hides it. There appears to be a little height difference between the first and the rest of the pages.
If you edit the footer ther is a checkbox in Word 2007 and 2010 that allows you to show it anyway. Don't know why SSRS exports it differently between the first and other pages.