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
Resolved Questions Bookmark and Share
bdennehy

EAN128 in Crystal Reports

Hi,

I am looking to recreate an EAN128 label in Crystal Reports. Currently we have a program where the labels have to be entered manually but we are looking for our ERP to automatically produce the labels once the products are selected.
We bought IDAutomation C128 font advantage package and the Crystal UFL.
The formula we use to generate the barcode is
IDAutomation_Code128ApplyTilde("Ô17"+ totext({?BB},"yyMMdd")+"Ô01"+{Enter.Barcode HR})

?BB is a parameter for the best before date and enter barcode is a database field. At the moment our partners cannot read the barcode. They can read the barcode from the previous program perfectly but not our crystal generated ones.
When I scanned the barcodes I saw two differences between the Crystal generated barcode and the barcode in the preogram.
The Crystal generated barcode starts with the Date, then a symbol like a hook,then the 01, then the barcode, then (21)
The program generates the Date,then the 01, then the barcode, then (23)

I would like to know how can I generate our barcodes in the same format i.e. without the symbol after the date and with (23) instead of (21). Should I use a different formula or different font etc...

Any help on this would be greatly appreciated.

Thank you for your time.



03-23-12     2864 day(s) ago    

  Report Abuse

 

Ben

Best Answer

I re-created the barcode using your data and the scanned result without identifying the FNC and AI is: ~21217141231~2120105099879001008

When I scan the barcode into the ASCII String Decoder (which will reveal characters for AIs), I receive:
17141231<GS>0105099879001008

ASCII STRING DECODER: https://www.idautomation.com/scanner-decoder/

When I enable Decode FNC1 into the scanner and scan the barcode, the result is:
]C117141231<GS>0105099879001008

All of the results are correct and the encoder is doing exactly what it is supposed to do. Programming the scanner to decode the FNC1 is also correct.

You do not mention if you are encoding fixed length fields. That could possibly be the issue. If so, please view:

If the FNC1 is not required for fixed length fields, you can leave them out, meaning leaving the ~212, etc out of the fixed length and include them in the variable fields.

Please view Code 128 GS1 at:
https://www.idautomation.com/code128faq.html#Creating_GS1-128

Symbol Size Reduction: The methods represented above insert FNC1 codes into the symbol. If symbol size needs to be minimized, multiple AIs may be included in a single barcode without encoding additional FNC1 codes, provided that variable length AIs are included last. The parentheses may not correctly appear in the text interpretation of the symbol when using this method of encoding, however they may be easily included by inserting a custom text field near the symbol if required.

If that is the case, then you could use:

~21217141231~0290105099879001008

Posted 2860 day(s) ago

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

Ben
Can you provide me with sample data (full value with FNCs, AI, etc) that is used to generate the barcode so that I can re-produce the issue?

Please also send the barcode to PDF and send it to support@idautomation.com

You may also want to scan the barcodes into the ASCII String Decoder to reveal any hidden characters, such as the AIs that you are encoding.

Free ASCII String Decoder:
https://www.idautomation.com/scanner-decoder/

Posted 2861 day(s) ago

(0)
(0)
   Report Abuse

bdennehy
Hi,

I tried that but unfortunately it still picks up the Fl character before the first AI and before the second AI? I tried a number of different combinations of the formula hardcoded but the result was the same.

Can I ask what this symbol means and should it just appear once at the start of the code? And if it should only appear once any ideas why it would appear twice? Spacing, parenthesis etc??

When I removed the Expiration date the code is picked up and identified.

Sorry I didn't shed much more light on the problem.

Posted 2861 day(s) ago

(0)
(0)
   Report Abuse

bdennehy
Thanks, I'll try that and post my results on Monday.

Posted 2864 day(s) ago

(0)
(0)
   Report Abuse

Ben
It appears that you are using the ApplyTilde function with the Direct ASCII Method. I am not sure if it is causing the problem or not. However, as a test, you could always hard code the value and see how it encodes the data.

For example (but use your own data value from database)
IDAutomation_Code128ApplyTilde("~21217"+ "1234567890","120323" +"~21201"+"1234567890")

It might help determine the issue.



Posted 2864 day(s) ago

(0)
(0)
   Report Abuse

bdennehy
Just to update my question. I think the (23/21) at the end had something to do with wrong scanner settings but I suppose they still should be the same, but it is not appearing once the scanner was corrected.

The symbol has changed to something similar to small F with a l F up high and I lower - Fl

Not sure if this helps but worth correcting.

Thanks again.

Posted 2864 day(s) ago

(0)
(0)
   Report Abuse
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://" or "https://")
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://" or "https://")
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 2019 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