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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Print Landscape in Reporting Manager

Author  Topic 

dmlJun2009
Starting Member

4 Posts

Posted - 2009-06-26 : 16:51:46
Hi,

I've seen many topics regarding printing reports from SSRS, but since I'm new to this forum, SQL and SSRS, can someone please assist me in setting up a report to print landscape. My report in SSRS has a width of 11.0in by length of 4in, the length can grow. The report looks on preview, and our intranet when I deployed it, however, when I try printing it, it will always be set on portriat and likewise, when it is exported as an pdf it is also portiat and flow over into two pages. Any help is greatly appreciated.



dmlJun2009

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-27 : 01:47:58
the printer decides on format based on report dimension. what are current values set for report body dimension?
Go to Top of Page

dmlJun2009
Starting Member

4 Posts

Posted - 2009-06-29 : 12:16:15
I checked the report properties and I found the below settings:
InteractiveSize: 8.5in,11in
Margins: 1in,1in,1in,1in
PageSize: 8.5in,11in

I changed the settings to the below and the report works great:
InteractiveSize: 11in,8.5in
Margins: .01in,.01in,.01in,.01in
PageSize: 11in,8.5in

Thank you very much for your help.





dmlJun2009
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-29 : 12:39:07
welcome
Go to Top of Page
   

- Advertisement -