SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Landscape vs Portrait printout


Landscape vs Portrait printout

Author
Message
csherwood
csherwood
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 1

How do you tell it you want it to print landscape? I have set the format of the report to 8/5 x 14, but when I try to print within the VS ide it prints portrait and, of course, only half the page. I try to export to PDF and again it is portrait. My report has so many columns that I need to do it in landscape. How is this accomplished????





Bret Miller
Bret Miller
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 24

Can you adjust your orientation in print setup? For example, your pdf-exported version gets loaded with Adobe Reader. If you go to File, Print Setup and choose Landcape orientation, doesn't it print landscape?

Semi-unfortunately, it seems that rendering and printing features have been completely separated. I would think that Adobe Reader would default the orientation to landscape if the page size was 11 x 8.5, but then that would be logical and not all programs operate that way.


csherwood
csherwood
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 1
yes, it prints landscape, unfortunately the report was exported in portrait, therefore it does me no good. In other words, only half the columns appear per page and there are twice as many pages as there should be, since it continues the other half on another page.



Bret Miller
Bret Miller
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 24

Sorry, I don't see that problem here. When I set my page size to 11 wide by 8.5 long, it exports as a landscape document in PDF. I did find the following note at http://sqljunkies.com/WebLog/ktegels/articles/1526.aspx, which may help explain the issue you're seeing:

"When attempting to export a report in landscape format to Adobe Acrobat Printer your default printer must support landscape mode.

"While researching the capabilities of SQL Reporting Services my default printer was set to "Microsoft Office Document Image Writer" which only supports portrait. Every time I extracted to Adobe, my reports were saved as portrait. After I changed the default printer to a driver that supported landscape mode I was able to extract the report to Adobe in landscape mode."

Check to make sure your default printer supports landscape mode.


csherwood
csherwood
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 1
I set my printer preferences to landscape and that seemed to work. Thanks



morningdew
morningdew
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
My default printer supports landscape, but still exports pdf in portrait. Any suggestions?



csherwood
csherwood
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 1
Are you setting the page size to 11 x 8.5 in the lay out options for the report. Also make sure that you are not overflowing the margins. I found that you need to look at the properties of size for the body,report, and headers in the report. They were set too wide on mine and causing some margin overflows. I have also found that the page sizes are not translating to the printer. Even thought the print preview shows landscape, when I go to print, I have to change the printer properties to landscape.



jamie
jamie
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 1

Hi,

I have had this problem too.

In the end I used a browser control and set the printer options before rendering the report to the control.

Jamie





csherwood
csherwood
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 1
Okay, guess it's because I don't have any training on this, but how do you set the printer options programmatically before rendering. I simply have created a report project and don't see any where to do that.



F.A.
F.A.
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

Hi,

I am trying to print a report on legal size paper (landscape). When I run the report from IE, it seems to make it landscape but does not automatically select legal paper. Is there a way to change it for that specific report, so that when I use the print option in report manager, it automatically selects legal?

Any suggestion would be highly appreciated!

Regards,

F.A.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search