the table above shows a list of the fields i am pulling from a BAQ from our UD01 table, i have added parameters to this so you need to enter the OrderNum / OrderLine / OrderRelNum to filter down the data accordingly.
i want to create a label for each panel size and quantity which displays the O/L/R, size, qty x of x and the panel reference.
so to add some clarity, in the dataset above IWP-224a is 1 panel at 5520 so i want 1 label
IWP-132-900F has 2 panels at 900 so i want to print 2 labels for this one.
ideall the finished article should look similar to this…
To make sure I understand correctly, you want to print labels like on a Zebra printer?
It should be somewhat straightforward. You will need to make sure your report page size matches up with your label sizes. It can get tricky with the margins, etc. In my experience, it’s a bit of trial and error as you lay it out and get it to fill the label properly.
Another thing to consider which I’ve dealt with is printing the labels in a specific sequence and/or a varying number of labels which matches a quantity on a job/order.
And I think I missed the main point of the question. You’d open up the SSRS report and then adjust tha page size to the label size first. Then you’d place your components in there just like you have shown. I believe I usually start by placing a tablix using the wizard and grab my BAQResults dataset. At this point, I don’t want a full blown table so I would only grab one field for now - no grouping. Delete the header row. Then you’ll have a single row and column (aka a cell). Insert a rectangle in this cell first. Then you can place textboxes as necessary to create the layout you want.
This is a tougher one and I’m short on time, (getting a flight out of Ohare in 30)
We are doing some internal testing on a Kinetic AI Consultant and this is what it gave me. It’s still BETA and has more testing but this may get you moving in the right direction. Let me know if it helps at all. SSRS Report Help.pdf (74.1 KB)
I seem to recall that the job traveler does this with serial numbers, so you may be able to look there for inspiration. I think it was done with a sub report, but the numbers were already generated.
The hacky way to do it is to create that many records in your baq so that you get that many labels. Like have a UD table with records numbered 1-100 or whatever the maximum number of labels should be and join your real data to that table on row number <= quantity of labels that you want. That will introduce the duplication into your dataset to get the extra labels.
