print report orientation

125 pts.
Tags:
Oracle Reports 10g
i have one report ,when runing the report , the data displayed on 2 pages portait. i want the report to display first page (portrait) and the second page (landscape) so ,how change orientation between 2 sections hlp pls ?
ASKED: July 8, 2009  10:56 AM
UPDATED: August 12, 2011  3:08 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You could try this in the On Page event:

If Me.Page = 2 Then
Me.Printer.Orientation = acPRORLandscape
End If

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SpyMoose
    As far as I know there is not a way to set up the printing preferences for subsequent pages. You could set it to print page one as portrait and print it off, then set page two to landscape and print that one only. It's a bit more time but may work.
    625 pointsBadges:
    report
  • Eldon
    You can have a different orientation for each of the 3 sections: Header Section, Main Section and Trailer Section, but not multiple orientations within each section. If your report requirements can be squeezed into those restrictions (e.g. if you only need the first and/or last page of the entire report to be a different orientation) then I can see a way forward. Otherwise, you might need to abandon Oracle Reports as your report engine for this one, and try something else -- e.g. make it a word processor merge document. If you give us some more details about your report specification we may be able to help more. Regards, Eldon
    60 pointsBadges:
    report
  • Eldon
    @Randym: This question is about Oracle Reports 10g, not Microsoft Access.
    60 pointsBadges:
    report
  • Rianne
    You can split a section, and then you can change one of them to the right lay-out.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following