Home > IT Answers > Oracle > print report orientation
Army
105 pts.
 print report orientation
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 ?

Software/Hardware used:
ASKED: July 8, 2009  10:56 AM
UPDATED: August 12, 2011  3:08 PM
RELATED QUESTIONS
Answer Wiki:
You could try this in the On Page event: If Me.Page = 2 Then Me.Printer.Orientation = acPRORLandscape End If
Last Wiki Answer Submitted:  July 9, 2009  2:12 pm  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

SpyMoose
 625 pts.
 

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

Eldon
 60 pts.
 

@Randym: This question is about Oracle Reports 10g, not Microsoft Access.

Eldon
 60 pts.
 

You can split a section, and then you can change one of them to the right lay-out.

Rianne
 25 pts.