When I had to create a project like this I created two seperate
reports one page that you need to print portrait and one report for
the page that you need to print landscape.
After creating those two reports create a new report and insert the
two reports above as subreports. If you have a button to print the
report have it point to the third report that you created.
This might not be the cleanest way to get this done but it did work
for me.
Wow, I am surprised that your solution works. I was always under the
impression that the report controlled the elements such as page orientation,
paper size, etc. The sub-reports simply used the main report's settings.
I guess I will have to remember to test this.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County