Creating Crystal Reports delivery labels with different references

5 pts.
Tags:
Crystal Reports
Crystal Reports formulas
Crystal Reports XI
Hi,

We have a delivery label which is creating a reference number for each label.

if isnull({BoxLabel.JobNo}) then "*WWPML0" + {BoxLabel.OrderNo} else "*WWPML0" + {BoxLabel.JobNo} + "*"

This works fine. However we need to now amend this so that the reference number changes if there is more than one box. the next box would have a reference number like *WWPTR012345* (with the 12345 being the {BoxLabel.JobNo}, subsequent boxes would have the 0 replaced with the next number, ie *WWPTR112345*, *WWPTR212345*, *WWPTR312345*, and so on.

We have a table called BoxLabel and the total number of boxes appears per order within the table. So order 12345 will have an entry in field Boxes of 4.

The end result should be as follows:

Box 1 WWPML012345

Box 2 WWPTR012345

Box 3 WWPTR112345

Box 4 WWPTR212345

Is this possible?????

Thanks in advance, Kwirky



Software/Hardware used:
Crystal Reports XI
ASKED: August 20, 2010  1:50 AM
UPDATED: August 20, 2010  1:09 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following