Advanced help needed for report formating

C

connecttodaniel

I need help with the printing order of a report.

We have a networked copy/print machine with duplex,
sorter, and folder. I need a report printed in booklet
format (8.5 * 11 inches folded to 5.5 * 8.5). The printing
software does not support booklet printing as I need (the
copier determines a ratio of 8.5” by 11” and resultantly
leaves approx 1.5 - 2” blank space in the “footer” –
unprintable region because of ratio. If I change paper OR
print size to 5.5 by 8.5, the printer requires special
paper, even when the booklet print style or duplex [either
side or top] is selected). The two pages per sheet doesn’t
work either.

Summary: the printer software doesn’t do what I need.

E.g., a 12 page report = 3 pages front and back, with two
5.5 * 8.5 positioned side by side. The first problem is
page ordering…

Sheet 1 side a – page 12, page 1
Sheet 1 side b – page page 2, page 11

Sheet 2 side a – page 10, page 3
Sheet 2 side b – page 4, page 9

Sheet 3 side a – page 8, page 5
Sheet 3 side b – page 6, page 7

If the report size increases, the numbers obviously must
follow the same pattern.

What I need is code or a macro (with the ‘onformat’
or ‘onprint’ property?) that will order the report pages
accordingly.

The second problem is that margins need to be specially
adjusted. If margins are: .5” top, .5” bottom, .25” left,
and .25” right, the center of a page must have the total
of the right and left margin (in this case, one-half inch)
to compensate so that after folding, the pages will have
proper margins.

Regarding both issues, I have tried virtually every
combination of report properties, page setup, and printer
options, but have been unsuccessful.

You can reply to this message or
email "(e-mail address removed)" Any help is much
appreciated. Thanks.


Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top