Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SRSS 2008 Export to Word - Wrong page orientation

Author  Topic 

elizaut
Starting Member

6 Posts

Posted - 2009-06-16 : 07:56:13
SRSS 2088; Office 2007

I have posted about this issue before but found out some new information. When I export any report (even a new one I have created to test) to Word 2007, the Page Orientation says the report is landscape, which it should be (Interactive and Page size both set to 11 X 8.5). However, when I print, it prints portrait. When I go into the custom margins, the Margin Orientation says portrait. So the page orientation says landscape and the margin orientation says portrait. Any idea on how to fix this? I can change it manually and print, but I don't want to tell 5,000 users they need to change it :).

Thanks in advance,
David

yavvie
Starting Member

46 Posts

Posted - 2009-06-23 : 10:40:01
have you tried setting in report properties the PageSize to 29,7cm; 21cm (A4 page) and maybe InteractiveSize to 29,7cm; 0cm?
Go to Top of Page

elizaut
Starting Member

6 Posts

Posted - 2009-06-23 : 10:47:03
Thanks for the reply. Microsoft said that it was a bug and they are going to release a fix in the next 1-2 months. However, I will give your suggestion a try.
Go to Top of Page
   

- Advertisement -