Avatar of Tim
Tim
Flag for United States of America asked on

Need help with placing a 128 barcode on a Crystal Report

I am trying to update a Crystal Form that came with our ERP system and add a barcode that represents the quantity shipped on a packing slip. This form already has barcodes on it and are working good but when I try to set a barcode with the quantity shipped it splits the barcode and places the quantity barcode below the field then places another barcode on a new line above the Quantity field. I think it is because the quantity is 6.00 and not just 6. In addition to adding this barcode I am changing the code on the existing barcodes from 3of9 to 128. All the previous barcodes converted fine it is the quantity field that is causing me issues. How can I fix this issue. I am using IDAutomation barcode/fonts and I have followed their instruction set but am still getting this issue/error.
Crystal Reports

Avatar of undefined
Last Comment
Tim

8/22/2022 - Mon
Mike McCracken

Try using CSCtr or ToText to strip the decimals

CStr({YourField},0)

ToText({YourField},0)

mlmcc
Tim

ASKER
Thanks for the suggestion but I had tried that and it didn't fix the problem. I did some more testing on some different orders that had more lines and found that this issue only occurs on the first line and the subsequent lines do not produce the extra line. How can I suppress or even find out why this extra line is being created when the document is formed. I have attached an example of the issue on this case.
FormSnippet.jpg
Mike McCracken

It looks like your data has a record with no item

mlmcc
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Tim

ASKER
I still cannot find out how to fix this issue. Is there anyplace in the crystal form where I can suppress this extra record? When I look at the field in raw form without the barcode it shows the extra field with no start bit. I would put the actual code I am getting but they all have special characters on the top of the letters. I reached out to IDAutomation in hopes they could help but they say their barcodes are good so all I can do is work with the form but I still don't see in the form where it says create an extra line when It encouters extra data. When the field prints it shows the correct qty (6.00) but when I put the barcode in the main barcode contains 6.00 but the extra field is always the same. How can I troubleshoot this? The data comes from the datastream in our ERP system so I cannot use preview to see anything nor can I browse the data on the form.
Mike McCracken

Can you upload the report?

mlmcc
ASKER CERTIFIED SOLUTION
Tim

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.