Wednesday, May 02, 2012 5:41 PM
I am having an issue with the paper size not being set when rendering my report to WordOpenXML format. I am using SSRS 2012. In my report properties, I am setting all available page properties to Letter, 8.5x11 in order to try to get this to work. My report body is also set to a PageSize and Interactive Size of 8.5x11. When I render the report to WordOpenXML and open the Word document, the paper size is not set when going into Page Setup. This causes issues when printing because the printer will either return an error or make you explicitly choose a paper size yourself.
However, if I render this same exact report to Word format, the paper size is correctly set in the Word document and it will print correctly with no issues. So there seems to be a different in the rendering logic between these two formats.
Please let me know if you have any information on this issue.
Monday, May 07, 2012 4:02 AMModerator
When we export a report to WordOpenXML in Reporting Services 2012, the Word page height and width are set by the PageSize and Margins RDL properties. So, the pagesize should be 8.5in x11in either after you export the report to WordOpenXML. At this time, I suggest that you deploy the report to the report manager and then try to export the report from the report manager. Meanwhile, I suggest that you verify the WordOpenXML extension in the RSreportServer.config file. Please be sure to make copies before modifying any config files. The WordOpenXML extension should be:
<Extension Name="WORDOPENXML" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>
Exporting to Microsoft Word
Monday, May 07, 2012 5:21 PM
Yes, I can verify that I have the appropriate WorkOpenXML extension in my RSReportServer.config file. I have tried rendering this report through the BIDs designer, through code using the Render method, and through the Report Manager. In each case, if I export the report to the DOC format, the PageSize is set correctly. However if I export the exact same report in the DOCX format, the PageSize is not set/recognized in Word. To me this would appear to be a bug.
Have you tried to test this yourself with a simple test report? I am running Windows 7 32 bit, Microsoft Office 2007, and SQL Server 2012.