Getting a report to print a qty of pages when there is only one record shown!!

[Matt Brown]

Just designred a c of c database which allows the shopfloor test guys to create an outgoing c of c.
The database holds the following fields:

C of C Number
Date of Issue
Customer
Part no and iss
Batch No
Qty
Despatch/Invoice No
Description of items
Details of tests
Concessions
Authorised for release.

The database works just fine, the guys on the shopfloor have just added a little twist to the reporting which i'm struggling over.

A C of C may be raised for say a qty of 10.
What they want to be able to do is print 10 copies of the report (which is straightforward enough, just add 10 to the amount of copies in the print dialogue box) BUT!!!, Each copy must then say 1 OF 10, 2 OF 10 , 3 OF 10, 4 OF 10, 5 OF 10 etc etc...

Not so easy as when the report is run only one page is shown on the print preview, which in fact is correct as only one C of c acually exists in the database.

There is a query behind the report which is used to print the current record shown on screen.

Any help or ideas with this will be appreciated to the max!!

Thanks

Matt

 

[79ssecca]

I think I would store the number of copies they want as a global. then only print one copy at a time, inother words don't set the copy count to ten leave it at one but execute the copy comand ten times via a loop. That loop would also have to send data through to the report or to a global that the report could read to get it c of c value.

Just an idea
Good luck

 

[Matt Brown]

Hi,
I can sort of see where your coming from though trying to code it may be harder to do.
I think the loop would do the job as i could get the loop to look at the Qty field and loop through X amount of times and produce X amount of pages though i'm not sure how to send that data to the report to tell it i need this amount of pages.

Any extra help on this anyone (mentioning no names Pat H)