Creating Multiple Labels based upon quantity of item
Creating Multiple Labels based upon quantity of item
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.
-
- Posts: 5696
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating Multiple Labels based upon quantity of item
Hello,
Please check the sample report in the attachment.
Thank you.
Please check the sample report in the attachment.
Thank you.
- Attachments
-
- ReportCountData.mrt
- (776.94 KiB) Downloaded 32 times
Re: Creating Multiple Labels based upon quantity of item
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.
-
- Posts: 5696
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating Multiple Labels based upon quantity of item
Hello,
In that sample, not counter is used. The data column is set as a count for the DataBand.
Thank you.
In that sample, not counter is used. The data column is set as a count for the DataBand.
Thank you.
Re: Creating Multiple Labels based upon quantity of item
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
https://www.dropbox.com/sh/alfjlmlrud6a ... m7-oa?dl=0
-
- Posts: 5696
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating Multiple Labels based upon quantity of item
Hello,
The expression with where count is set, should be placed on the main band.
Thank you.
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 33 times
Re: Creating Multiple Labels based upon quantity of item
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
https://www.dropbox.com/sh/alfjlmlrud6a ... m7-oa?dl=0
-
- Posts: 5696
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating Multiple Labels based upon quantity of item
Hello,
Please send us test data for your report.
Thank you.
Please send us test data for your report.
Thank you.
Re: Creating Multiple Labels based upon quantity of item
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.
-
- Posts: 5696
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating Multiple Labels based upon quantity of item
Hello,
At the provided link your report is without data. We can not run it.
Thank you.
At the provided link your report is without data. We can not run it.
Thank you.