Creating Multiple Labels based upon quantity of item

Сonversation on different topics
mchmura
Posts: 9
Joined: Fri May 26, 2023 3:43 pm

Creating Multiple Labels based upon quantity of item

Post by mchmura »

I am trying to make labels to place upon our product and I am having difficulty with creating multiple labels that have a quantity of more than one. Example: part a has a quantity of 1, part b has a quantity of 1, and part c has a quantity of 3. I need to create 1 label for parts a and b, but would need 3 labels for part c. I can only get the report to produce one label for each part. I built the report using the Label Report Wizard.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Multiple Labels based upon quantity of item

Post by Lech Kulikowski »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ReportCountData.mrt
(776.94 KiB) Downloaded 127 times
mchmura
Posts: 9
Joined: Fri May 26, 2023 3:43 pm

Re: Creating Multiple Labels based upon quantity of item

Post by mchmura »

This didn't work properly. I may have Assemblies that we need a quantity of more than one, while others only need a quantity of one. This report provides different categories and then just adds an additional instance each time, similar to a counter (n=n+1). I need to reference the quantity of the assemblies to determine how many instances of the label need to be created. The quantity of the assemblies are not reliant upon the name of the assemblies, nor do they align in any pattern.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Multiple Labels based upon quantity of item

Post by Lech Kulikowski »

Hello,

In that sample, not counter is used. The data column is set as a count for the DataBand.

Thank you.
mchmura
Posts: 9
Joined: Fri May 26, 2023 3:43 pm

Re: Creating Multiple Labels based upon quantity of item

Post by mchmura »

I almost figured out what i need. The issue i am still having is that one file produces the correct number of labels, but doesn't fill the sheet properly. The other fills the sheet properly, but doesn't produce the correct number of labels.

https://www.dropbox.com/sh/alfjlmlrud6a ... m7-oa?dl=0
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Multiple Labels based upon quantity of item

Post by Lech Kulikowski »

Hello,

The expression with where count is set, should be placed on the main band.

Thank you.
Attachments
UDR_Stickers_Report_Development-3.mrt
(37.46 KiB) Downloaded 138 times
mchmura
Posts: 9
Joined: Fri May 26, 2023 3:43 pm

Re: Creating Multiple Labels based upon quantity of item

Post by mchmura »

That file didn't resolve what i was looking for, it just added an duplicate count line at the top (which would actually throw off the labels when they print) The line added was already present in the bottom right corner of each part label. I have attached a a link to a few images of what is produced by each report, versus what is desired (i edited a screenshot in paint to produce the desired appearance)

https://www.dropbox.com/sh/alfjlmlrud6a ... m7-oa?dl=0
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Multiple Labels based upon quantity of item

Post by Lech Kulikowski »

Hello,

Please send us test data for your report.

Thank you.
mchmura
Posts: 9
Joined: Fri May 26, 2023 3:43 pm

Re: Creating Multiple Labels based upon quantity of item

Post by mchmura »

i don't know what you mean. the link i attached before had the files that were used and showed what they produced in the image files.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating Multiple Labels based upon quantity of item

Post by Lech Kulikowski »

Hello,

At the provided link your report is without data. We can not run it.

Thank you.
Post Reply