I'm using crystal report to create labels for production not sure if this is a smart idea but I don't know what else I can use, if anyone has another suggestion I would be happy to hear it.
Here is what I am done and here is where I am stuck...
The label is a 8.5 x 5.5 stick laserjet label.
2 per sheet to make a 8.5 x 11 lasersheet
my label uses Parameters, so when our users here put in a product code, the rest of the label is filled out with the Database.
Now my problem is A I don't' know how to get this label to repeat I can get one label to display but for example if we need 40 label for 40 boxes we are producing I don't' know how to tell it print 40 unless i use the print command and select 40, but here is why I can't do this. I wanted to have a consecutive numbering for the boxes so each label in the top corner it would state: box1, box 2, box3 ..... I can't figure this out either, I was thinking maybe using page # but since their is 2 labels a sheet the next page would be page #2 but yet label 3.
2 more areas of questioning, some of our product are UL approved therefore I want to place the UL logo (jpg)on the label only if our product starts with either "P" or "H" and last but certainly not least actually most confusing. I am also adding QRCODES to each label therefore when the user enters the product code I would like the system to go into my directory of QRCODES/BARCODES and place the (product specific) jpg also on the label. Lots of questions but my 1st step is the box#'s and the repeating functions. Any help is appreciated.
Thanks
Here is what I am done and here is where I am stuck...
The label is a 8.5 x 5.5 stick laserjet label.
2 per sheet to make a 8.5 x 11 lasersheet
my label uses Parameters, so when our users here put in a product code, the rest of the label is filled out with the Database.
Now my problem is A I don't' know how to get this label to repeat I can get one label to display but for example if we need 40 label for 40 boxes we are producing I don't' know how to tell it print 40 unless i use the print command and select 40, but here is why I can't do this. I wanted to have a consecutive numbering for the boxes so each label in the top corner it would state: box1, box 2, box3 ..... I can't figure this out either, I was thinking maybe using page # but since their is 2 labels a sheet the next page would be page #2 but yet label 3.
2 more areas of questioning, some of our product are UL approved therefore I want to place the UL logo (jpg)on the label only if our product starts with either "P" or "H" and last but certainly not least actually most confusing. I am also adding QRCODES to each label therefore when the user enters the product code I would like the system to go into my directory of QRCODES/BARCODES and place the (product specific) jpg also on the label. Lots of questions but my 1st step is the box#'s and the repeating functions. Any help is appreciated.
Thanks