Determine copy number within Report

B

Barry van Dijk

I'm opening a report using PrintOut to get multple copies.

While this is an invoice, I'd like to print the word 'Copy' on every page
where number of copies > 1.

So I'd created a simple label which visibility I can set to true of false.

But how can I determine which copy I'm at?

I can count pages, how can I count copies.

(And no, I do not want to set a global variable which hold true or false to
print the word copy, because I'm printing to a PDF printer which collect all
copies into 1 pdf)

Thanks in advance...
 
D

Duane Hookom

Have you considered creating a table [tblCopies] with 1 record for each
copy:

[CopyNum] [CopyTitle]
1 Original
2 Copy
3 Copy

Add this table your report's record source and don't join it to any other
table. Add the two fields to the query grid to make them available in the
report.

This will create 3 "copies" of each record in your report. You might need to
adjust your sorting and grouping.
 
W

Wayne Morgan

The main problem I see here, is that unless you set up your own loop to
print the copies, one at a time, you can't. The problem is that if you
simply tell the printer driver to print multiple copies, one copy is sent to
the driver then the driver sends the print file to the printer the requested
number of times. If you are changing a readout on the report to show a copy
number, then they aren't copies, they're different, and need to be sent one
at a time.

Since this in an invoice, do you always send the same number of copies? How
many pages are in each single copy?

Some options:
1) Add a page break after each page and repeat the invoice as many times as
needed. In other words, if it is a 3 page invoice, make a 3 page report.

2) Use something similar to printing multiple copies of the same label to
generate the subsequent copies, making your label visible on the copies
after the first one. This has the advantage of reducing the number of
controls on the report so that you don't exceed the maximum by making copies
of the first page. It also lets you specify the number of copies you need.
There are two parts to the link below, one is to skip previously used labels
on a sheet, the other is to repeat printing the current record. The repeat
part is what you need.

http://support.microsoft.com/default.aspx?scid=kb;en-us;299024
 
Top