Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to generate a report in Landscape:

Status
Not open for further replies.

Ngabay

MIS
May 16, 2003
25
US
Hey Guys,

I have a report with many collumns and I want to print it in landscape. When I try increasing the width I get an error saying that the report width is greater then the paper width. How do I generate a report in Landscape?

Thanks,
Nir
 
You have to set the default printer paper to suit your report size, oreintation and all. Once set, your report will reflect the printer paper size/oreintation
 
Download Pageset.dll from microsoft site. it has got method s to change orientation programatically. so that you can change orientation at runtime before viewing report.
 
If you have VB6 with SP5 then just use:

dr1.Orientation = rptOrientLandscape

where dr1 is the DataReport name.

SP5 is available from:


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top