printing reports in portrait and landscape

[abenitez77]

I have 5 reports. Report 1 is the main report and I have report 2 - 5 as subreports at the footer level that print after report 1. Report 5 has a lot of fields and I want to be able to pring report 1 - 4 as portrait and report 5 as landscape. Report 1 - 4 will be printing claims. The table that is being used is "Claims" and has about 100 records and each record is a claim. Reports 1 - 4 uses this table. The claims field is called "ID". On report 5, it is printing using a different table called vendors and the main column is vndrNum which is also a column in the claims table. How can i accomplish this?

Currently I am able to view all 5 reports correctly but report 5 is being cut off because it is not coming up as landscape even though the report 5 itself is set to landscape. It is in report 1 as a subreport and report 1 is in portrait.

 

[dhookom]

The subreports don't understand anything about page layout or setup or margins or orientation. They inherit these settings from their main report. You may need to print any landscape reports separately.

Duane
Hook'D on Access
MS Access MVP

 

[abenitez77]

thanks that's what i did.