Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS: Wrong Paper Size...
Microsoft Dynamics CRM (Archived)

SSRS: Wrong Paper Size Set When Exporting Landscape Report to Word

(0) ShareShare
ReportReport
Posted on by barmstrong 75

Hi,

I've come across a strange problem with SSRS reports when exporting to Word. I have a report which needs to fit onto 1 landscape A4 page. When I preview the report in CRM, it displays correctly and will print without any problems. Similarly, I can also export the report as a PDF and it prints without any problems. However, when I export the report to Word, the Word document Page Size gets set to either "Custom" or "Legal".

I have checked the Report Properties, Body Properties and Margins so I know that these are all correctly set.

The same problem occurs with OOTB reports which were created using the Report Wizard when I try to export them to Word (eg: Products by Contact) if they are exported as Landscape.

Has anyone come across a workaround for this issue?

I'm running CRM 2015 On-Premise (7.0.0.3543 )on SQL Server 2012 (v11.0.3000)

Thanks for your help.

*This post is locked for comments

  • Verified answer
    barmstrong Profile Picture
    barmstrong 75 on at
    RE: SSRS: Wrong Paper Size Set When Exporting Landscape Report to Word

    This issue has been addressed for SQL Server 2012 and 2014 in some of the available Cumulative Updates:

    https://support.microsoft.com/en-ie/help/3081150/fix-orientation-setting-is-lost-when-you-export-a-report-to-a-word-doc

    I've applied Service Pack 2 and Cumulative Update 11 to SQL Server 2012 (v11.0.3000) and this has fixed the problem. The Word renderer now correctly picks "A4" as the paper size in any landscape reports. 

  • barmstrong Profile Picture
    barmstrong 75 on at
    RE: SSRS: Wrong Paper Size Set When Exporting Landscape Report to Word

    Thanks David. I'll try posting this issue on the SSRS forum.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: SSRS: Wrong Paper Size Set When Exporting Landscape Report to Word

    This sounds like it's more a reporting services problem than a CRM one, as I don't think CRM will change any of the relevant report properties. My guess would be that it's an issue with the rendering to Word. Reporting Services does include some settings that are specific to the renderer, though I don't know of any that would cause this issue. I suggest asking in the Reporting Services forum

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,850 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans