C
connecttodaniel
I didn't get help from the reports newsgroup, but I
suspect the problem will involve some special visual basic
formating code or module.
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 "mailto:[email protected]" Any help is
much appreciated. Thanks.
Daniel
suspect the problem will involve some special visual basic
formating code or module.
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 "mailto:[email protected]" Any help is
much appreciated. Thanks.
Daniel