How to have 2 Different Printing Layouts for a 2 page macro print job (paper/PDF)

[bobby.bobby]

Hello all,

So I'm having an issue with my printing layouts, here is the situation:

I have a report which has two pages (First page is the data, and second page are the graphs, with a page break inserted in the middle). The problem I am having with regards to this is that the second page has 4 graphs, making the layout very stretched. Because the Print-area is selected with Macros due to the fact that my printing is made via a command button to execute the printing macros, I want to have the first page in a normal A4 format (streched, with narrow margins) and the second page to have the perfect layouts for the 4 graphs.
At the moment, the first page is too small because its using the content of the second page to lay itself out.

Anyone know if this is possible?

Here is the macro code i'm using to print at the moment:

Please Login or Register  to view this content.

Thank you in advance for your help!

[AlphaFrog]

This isn't tested, but maybe try something like this. It prints the 1st page then resets the zoom and prints the 2nd.

Please Login or Register  to view this content.

[bobby.bobby]

yeah it works nicely. However, it now prints off on two separate pages. Is there any way we can print on both sides while using this technique:

Please Login or Register  to view this content.

Also, if were to do it with printing PDFs, how would we change the code to have the same layout as above? (The below code 'Bugs'):

Please Login or Register  to view this content.

Thanks so much for your help!

[bobby.bobby]

Hi everyone,

Could anyone recommend a solution to this issue?