Combine Portrait and Landscaped reports into single Snapshot report

[talere12]

Does anyone know how to take 2 Access reports that are in different print formats, i.e. one is Landscape and one is Portrait and combine them into one report that maintains their individual formats? I am trying to send two separate reports out as one Snapshot viewer report but cant seem to make it work.

 

[AlanM]

May be a way

I had a need to do something similar, but with an individually-addressed portrait style letter preceding a landscape report for the addressee.

Only way in AC2000 I found I could do this was to:

- create the Access report as landscape
- report header visible NO
- page header visible NO
- "mydata" header visible YES
- put the letter content in text fields in the "mydata" header section, using the "vertical" option for the text fields, which effectively makes them "portrait" as the page is printed as a landcape style. It takes a bit of time [and head twisting!] to do the design as the fields are all turned through 90 degrees on the screen as you format and align them!
- insert a page break just before the detail section
- put the data content fields in the detail section.

So when we run this report, it produces portrait letters followed by data report in sequence, making for easy enveloping.

I had to play with the positioning of the page break, and also visibility of footers, etc to control repeating of any page headings needed for the landscape pages and the "portrait" pages.

Hope this helps.

Cheers
AlanM