Order serialization - label x of y
Hi . I am new to this community.
i am trying to create labels from an excel file. i have been able to add the data source with all the fields i
need for my label output. but i am stuck on the Label X of Y.
Here is my issue. I will have many lines of different item number/qty combo's.
Here is an example, i could end up with more items and Qty's just depending on order.
U12-160 order qty 57
U12-205 order qty 70
S20-310 order qty 65
so i want the result for the label x of y to be. Y = the total for all the lines 192
i would like U12-160 to start at 1 of 192.. but stop printing at 57
then U12-205 would start at 58 of 192 but stop printing at 128
item S20-310 would start at 129 until 192
i also have that order total of 192 in a column on each order detail line
so the order qty and the total for all line items are on each row.
any idea would be welcome.
As the total is on each row then this should be quite straight forward.
For the X, give this a default value of 1 and then on the Transforms set it to Increment and Reset to 1 Every Job as below:
For the Y value link this to the filed that holds the total number of label in the database.
On the File > Print screen, configure the Serial Numbers value (via the button to the right of the entry box) to Get Quantity form Database Field and link that the database field with the individual items quantities and then you are done.
Using a simple text database with this data
then the printed output would be0
Please sign in to leave a comment.