Report 3 pages per sheet of paper - top 1-10 middle 11-20 bottom 2

[Guest]

I am trying to print 3 pages per sheet of 8 1/2 by 11 paper the report is not
a problem but what I need is if there are 30 pages then the 1 through 10
would be on the top of the 10 sheets of paper then 11 through 20 would be in
the middle of the 10 sheets of paper and 21 through 30 would be on the bottom
of the 10 sheets of paper, any help would be appreciated...

 

[Joseph Meehan]

I am trying to print 3 pages per sheet of 8 1/2 by 11 paper the
report is not a problem but what I need is if there are 30 pages then
the 1 through 10 would be on the top of the 10 sheets of paper then
11 through 20 would be in the middle of the 10 sheets of paper and 21
through 30 would be on the bottom of the 10 sheets of paper, any help
would be appreciated...

Are you printing this from Microsoft Access, their professional database
program or some other program?

This is a newsgroup devoted to questions about MS Access. You may need
to ask your question in a newsgroup devoted to questions about the software
you are using. You may also want to check with a newsgroup devoted to your
printer as that can make a difference and you may need new or different
printer drivers.

 

[Guest]

Joseph,
Yes this report is a Microsoft Access Report, maybe I just was not clear but
if you set the length of a report so that three pages will fit on a sheet of
paper the first sheet of paper will have 1st page on the top of the 1st sheet
2nd page in the middle of the 1st sheet and the 3rd page on the bottom of the
first sheet then the 4th page will be on the top of the 2nd sheet of paper
and so on, but what I need is if there are 30 pages then the 1st through 10th
page would be on the top of 10 sheets of paper then 11 through 20 would be in
the middle of the 10 sheets of paper and 21 through 30 would be on the bottom
of the 10 sheets of paper, this is perforated paper and I wish to tear the
top off in one tear stack it on the top of the middle then tear off the
middle in one tear stack it on the top of the bottom and have everything in
order, and like I said before any help would be appreciated...

 

[Joseph Meehan]

Joseph,
Yes this report is a Microsoft Access Report, maybe I just was not
clear but if you set the length of a report so that three pages will
fit on a sheet of paper the first sheet of paper will have 1st page
on the top of the 1st sheet 2nd page in the middle of the 1st sheet
and the 3rd page on the bottom of the first sheet then the 4th page
will be on the top of the 2nd sheet of paper and so on, but what I
need is if there are 30 pages then the 1st through 10th page would be
on the top of 10 sheets of paper then 11 through 20 would be in the
middle of the 10 sheets of paper and 21 through 30 would be on the
bottom of the 10 sheets of paper, this is perforated paper and I wish
to tear the top off in one tear stack it on the top of the middle
then tear off the middle in one tear stack it on the top of the
bottom and have everything in order, and like I said before any help
would be appreciated...

Now I see what you are doing. I have had that same issue, I wish I
could remember for sure how I approached it.

Check out the "Force new page" property in the detail section.

 

[Larry Daugherty]

Hi David,

You haven't given us a clue as to the amount of work involved in your
current process and how much work will remain in any higher level of
automation. At first blush it looks to me like there'll be quite a bit of
manual work left; no matter how well you automate the rest of it. You have
perf and fold issues to deal with and you're going to have manual
separation/tear-offs with concatenation as a final step. It wouldn't be
worth the trouble to automate unless it's a process that you are doing
extremely frequently.

I recommend that you act as the calculator to resolve how many sheets total
in your print job and where the breaks will be. In your example given,
you'd print sheets paper 21 - 30 first. That will be Report pages 61 - 90.
Set the number of copies as required. Next print paper sheets 11 20 which
are Report pages 31 - 60. Same number of copies as before. Last, print
paper sheets 1 - 10 which are Report pages 1 - 30. Copies as before.

I thought/hoped that it might be possible to print the sections as Snapshot
files and then loop thru them with Script. Unfortunately, WSH doesn't have
a printer object so any print command has to be passed as a command line
option to the target application.

You may be able to find out something useful in the scripting groups.

HTH