crystal reports(v.8.5) via vfp7 NUMBER OF COPIES

[FILIPM]

Dear Colleges,

I finally got to run crystal reports 8.5 in my vfp7.0 sp1 application.

I have still one problem.
I make an sql statement for printing invoices or ....
For example :
client 1 has invoice nr 100 and need 3 prints
client 2 has invoice nr 101 and need 5 prints
......
I saw a code to print more than one example of a page
Orep.printout(.T.,2,.T.,pagenr,pagenr)
The question is how can I know or send to the spooler which page has to be print 3 time and the other 5 times because I don't know of how many page invoice nr 100 counts.
Is there any easy way to do this ?

Any help would be very usefull
Thanks,


FILIP MERLIER

 

[Mike Lewis]

Filip,

As far as I know, there is no way of printing a different number of copies of different pages.

Your best bet would be break the report up into separate versions, one for each client number (create a parameter on client number, and use that in the record selection).

Then, in your VFP app, for each client in the table, pass the client number to the report (via the parameter), and then print the report with the required number of copies.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[craigber]

Mike is correct. You'll have to send each client's invoices as a separate print job.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"