How do I print multiple labels based on a field in the database?

[JVV]

I work in a museum environment and have a need to print a variable number of labels based on a field in the database. For example, our wet specimens that we keep in jars, one collection may go into one jar and I need only one label. But, the next collection may have to go into 3 jars, thus I would need 3 labels and then the next collection may fit into 25 jars and I would need 25 labels, and so on and so on. I have looked at other threads and FAQs but have found nothing that would fit. There was one suggestion to create multiple detail sections and then suppress those not needed based on the value in the field. That wouldn't work because I would have to know the maximum number of labels that I would ever need and I don't know what that could ever be. Any suggestions greatly appreciated.

 

[chelseatech]

If you use a VB front end, and the OCX there is a property you can set to do this.
Use .DetailCopies and you will get as many labels as you like. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

If you can create an additional table in your database, you can use a technique I described in an old newsletter. Try the following link:

http://www.kenhamady.com/news0111.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com