PDF417 barcode value different than input string
I'm developing a barcode solution using the PDF417 barcode inside Crystal Reports. When I create my string (300+ characters) I'm using a formula inside of Crystal. The Input String value is a formula made of several other formulas, each formula being a specified value (order number, qty, date codes, etc.).
When I test the bar code I put my input string formula on the label to confirm the data is correct, and it is. The input string shows the correct formatting and proper string length, however when I scan the barcode there are several (20 to 30) additional characters, and these are always numbers. I've found that this happens when converting a number field to text and using it in the Input String. OrderHed.Number03 is the field being converted, this is in conjunction with Epicor version 8 (vantage) using Crystal XI r2.
I've found that the number field that is converted to a string will show all the numbers except the last number, and in the place of the last number is a 20 to 30 digit long string of numbers. for example, if the string is 000740564 when I scan the barcode the value will be 000740560000022246866666666666666668248510000 with many extra digits on the end replacing the last correct digit.
I have everything set to auto pretty much inside the PDF417 code converter.
Has anyone else encountered this issue, any idea as to what could remedy this? I've tried the following:
Making the barcode larger
making the barcode smaller
changing the font size
scanning with several different apps and phones
I've tried declaring it a string a couple of different ways I'll outline below, the field is OrderHed.Number03, so I'll use that in my example. These are in crystal's syntax:
Declared a string var and made the value a string variable and tried to insert it.
Created a second formula that calls the first and converts that to a string
Putting ToText() around all the formulas in the input string formula
Putting ToText() around just the OrderHed.Number03 formula inside the input string formula
Something I have found is that if I put a character at the beginning of the string, meaning if the string is 000740564 and I add an "A" in front of the string so it is A000740564 then it will scan correctly without the extra numbers. If I put the 'A" at the end of the string then it will still put all the extra digits in then the "A". So it appears putting the "A" in the front fixes the extra digit issue but can't be used as I need a specific number of characters for each value and adding an extra character would defeat the purpose of this barcode. I did try some other things with this though and none worked, like:
Adding the "A" and then trimming it out using the Right() function in Crystal
Adding the "A" then using the Replace() function to make it a "" value
Adding a "" value to the beginning of the number value
Combining the formula into another formula that is a string, so a string is at the beginning, still gives me the extra digits.
This has been a real head-scratcher. The issue is when converting a Number field to a string value inside a formula inside Crystal I get extra digits that should not appear in the text. Any information would be appreciated.
Crystal Report xi r2
12-03-15 7.4 year(s) ago