How do i design 2-pages report for duplex printer

[dealwi8me]

I 'm trying to design a report that will show on the front page all the data considering the Client (Name, Address, etc) and on the back page all the items than client bought last month.

How can i design it?

Thank you.

 

[GaryPanic]

ok - you need a page break
design your first page as you want it then the 2nd page (which will become the back page) as you need it below a page break

now open reprt desing mode go to print option - change the printer to spefic printer (even if there is only one printer - do it ) now set the page to print the way you want it - save report
that will do it (ie select tray and select duplex option - save )

 

[GaryPanic]

side note -

careful on duplex - if you ahve letter heading in your duplex - some printers are weird and they print page 2 first on the paper - so try it out and see what effect you need - you can do this in word - its a printer thing - not an access thing

mine here prints as it should page 1 first then page 2 - hwoever my old printer did page 2 first then page 1 - which throw every thing in the air as we need the printer to be normal 85% and then specila 15% of the time ..

 

[dealwi8me]

i tried this and i get the error message "The sum of the top margin, the bottom margin, the height of the paper header and the height of the page footer is greater than the length of the page you are printing on."

 

[GaryPanic]

i tried this and i get the error message "The sum of the top margin, the bottom margin, the height of the paper header and the height of the page footer is greater than the length of the page you are printing on."

Page set up and edit these
I presume its A4 your printing on

ok
set margins to say 10.00
thats your paper sorted now - your report header - makes sure that its not too large and also te footers..

gp

 

[dealwi8me]

the page is landscape with margins (top:10,bottom:10,left:5,right:5) and i get the same error message. The size of the report is greater than one page because i design it for two pages, using page break.

 

[GaryPanic]

OK- ensure that you printer knows that the page set up is landscape and that the last item on your righthand side will fit into the page - select the edge of the page in design mode and bring it to the left as much as possible.



try that and see what happens - failing this - make a copy of the d/base empty it and zip it up and post it here and I or one of the otthers will review - sometimes its just a . in the wrong place that throws it ..
gp

 

[GaryPanic]

OK- ensure that you printer knows that the page set up is landscape and that the last item on your righthand side will fit into the page - select the edge of the page in design mode and bring it to the left as much as possible.



try that and see what happens - failing this - make a copy of the d/base empty it and zip it up and post it here and I or one of the otthers will review - sometimes its just a . in the wrong place that throws it ..
gp

 

[GaryPanic]

it might at the end need to have a sub report in it -

 

[dealwi8me]

with your help i made it work. Thanks a lot!