View Full Version : Crystal Reports XI - Creating delivery labels with different references

08-20-2010, 12:31 AM
Author Message

Joined: 22 Apr 2010
Online Status: Online
Posts: 11
Topic: Creating delivery labels with different references
Posted: 17 Aug 2010 at 10:27pm
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 numbet 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,