Crystal Reports Labels

mark-labarge
mark-labarge used Ask the Experts™
on
I am preparing a label report. The data table that provides the label information may have 5 records and I need to print 15 labels. The number of labels is calculated based on information in the table but is completely unrelated to the number of records. If I calculate that 15 labels are required I want to print the label number 1 through 15 on each label. I have thought of using some kind of a group and printing the page number as the label number. Any suggestions would be greatly appreciated
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Is that 15 labels for each record or 3 labels for each record?

Crystal cannot just print labels without data.

mlmcc
WillOwner

Commented:
So if you want to print 3 labels for each record,  just duplicate the labels,  in the detail sections or group sections as appropriate

Author

Commented:
The data will consist of 1 record and will provide the information for me to calculate that 10 labels are needed. Next time it might be 50, next time 20 etc.

Author

Commented:
The data will consist of 1 record and will provide the information for me to calculate that 10 labels are needed. Next time it might be 50, next time 20 etc.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
One way to do this is to add a table to your database with the a single number field in a record.  The numbers can be 1 to 100

You add it as a table to te report.

In the were clause you use

 {NewTbale.Numberfield} <= CalculatedValue

mlmcc
WillOwner

Commented:
What determines the number of labels
WillOwner

Commented:
Ok I have an Idea, its a little cumbersome and a little dirty::

so you have the number of labels as a field in each record,  create  50 detail sections( I am not sure if there is a limit) with the duplicate labels,  then  suppress  the sections based on a formula  

ie section b {labelcount} <= 2  

section c {labelcount}<=3
.
.
.
.
.
50

Author

Commented:
Thanks for your help. I will try mlmcc's suggestion of the addition of a new table with number of records approximating the maximum number of expected labels. I will let you know how it goes.

When I add a comment does it automatically go to both of you fine helpers that have offered potential solutions?

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Yes,  all participant are notified of new comments.

mlmcc

Author

Commented:
Thanks

Author

Commented:
Thanks for your help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial