Identifying copies

[Peter Kinsman]

When printing a report with multiple copies, is there anything like a
"CopyNumber" property that could be used to identify the individual copies?
I suppose the alternative is to have a Label or TextBox and paste the
description in there.

Many thanks

Peter Kinsman

 

[Duane Hookom]

One possible solution is to create a copies table like:

tblCopies
===============
CopyNum CopyTitle
1 Store
2 Customer
3 Another One

Then add this table to the report's record source and don't join it. Add the
fields to the query grid and set the criteria under the CopyNum field to
something like
<=2
to get two copies.

Set the primary sorting and grouping level in the report to CopyNum starting
a new page following the CopyNum footer. This solution creates a number of
duplicates.

 

[Peter Kinsman]

The use of a Cartesian product is most elegant - especially as I think it
could be expanded by adding a "ReportName" field with criteria, so that the
one table could control the distribution of all reports.

Many thanks

Peter

 

[Peter Kinsman]

Because the report has a page count, Ia little more work was required.

1) [Pages] is the total number of pages in all of the copies, so I have
printed the page count as
[Pages] / Dmax("PageNum", "tblCopies")

2) [Page] needs to be reset for subsequent copies, so I have set it to 1 in
the OnFormat event of the PageNum Header. Having reread it, I think this is
the same as the online help suggests.

It seems to work anyway, which is always the main test.

Peter

1) could be overcome by printing
... " of " & [Pages] / Dmax("PageNum", "tblCopies")
but I cannot