SSRS Shipping Labels - split qty between boxes

Hello all,

I am trying to create an SSRS bar-coded label to replace a Crystal report that we have used prior. The label is a style of the generic Epicor packslip report. The report works great until we encounter a shipment that splits the quantity of a given part into 2 boxes. Here is an example with the first line containing 100 parts and the 50 remaining are in a 2nd box. They are the same part num and same PO num:

By my logic, I need a label for each “OurInventoryQty” value:

However, my report only generates one label, for the first line:

Are my struggles due to the RDD for “packslip”? Or am I trying to create a label function that is not going to pan out in the SSRS format? (I have also tried this in bartender but end up with the same result of only one label for 1st line).

Thank you,

Alice

Your SSRS groups might need to be by PackLine as well.
Is this what prints by default using the standard Label?

2 Likes

We sort of got around this by putting in a carton qty field in the pack line, and then used this to force the SSRS to print X number of labels per line. No reason you couldn’t use this X number of cartons to calculate from the line qty either for a qty on the label.

1 Like