Landscape vs Portrait printout

Question

Landscape vs Portrait printout

csherwood

SSC Eights!

Points: 823
More actions
April 21, 2004 at 1:02 pm

#107767

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????

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Bret Miller SSC-Addicted Points: 473 More actions · Answer 1

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 SSC Eights! Points: 823 More actions · Answer 2

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 SSC-Addicted Points: 473 More actions · Answer 3

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 SSC Eights! Points: 823 More actions · Answer 4

I set my printer preferences to landscape and that seemed to work. Thanks

morningdew Grasshopper Points: 15 More actions · Answer 5

My default printer supports landscape, but still exports pdf in portrait. Any suggestions?

csherwood SSC Eights! Points: 823 More actions · Answer 6

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 SSC Veteran Points: 284 More actions · Answer 7

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 SSC Eights! Points: 823 More actions · Answer 8

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. Grasshopper Points: 21 More actions · Answer 9

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.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 10

There are two properties in this but both are not equipped to perform the task. Here is what you need, right click on the base surface that gives you the layout property you need to set it there and then right click on the body of your report that converts all items into a drop down, look for the report item and also set the property there. But the above will not solve number of pages during export to PDF if you use 8.5/11 and you have images, I even tried Microsoft recommended Interactive page height 0. I also found 8.5/11 gives better printout of images than other setting which reduces your images to less than what they are and why I don't know.

Kind regards,
Gift Peddie