Earn Points & Redeem with attractive offers!
You can earn points, by asking, answering, voting questions and redeem with
attractive offers
. To view various available redemption schemes, please visit
"My Profile".
New User? Sign Up  |  Sign In  |  Help
Barcode support and tutorials from IDAutomation and the community. Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Ask
Ask a question. Make sure you select the correct category for the question.
Answer
Like to help others? Then browse through the open questions to answer their questions.
Find
Find answer by browsing the resolved questions.
     
Search for Questions:
My Profile

JLTek

Resolved Questions Bookmark and Share

PDF417 barcode value different than input string

I'm developing a barcode solution using the PDF417 barcode inside the crystal. 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, 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 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:

ToText(OrderHed.Number03,0,"")
Cstr(OrderHed.Number03,0,"")
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 convert 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" 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, this 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.

Thanks,
JL









Operating System: windows

Application: Crystal Report xi r2

12-03-15     573 day(s) ago     Views: 624

    Report Abuse

 

Ben

Best Answer

Are you using the IDAutomation UFL for PDF417 to encode your data? If so, consider using the PDF417 User Suite. It includes a PDF417 font formula for Crystal Reports.



Posted 573 day(s) ago

()
()
  Report Abuse
 
   Find Interesting  
   Email to Others  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2017 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook