Open Forum

Expand all | Collapse all

2D barcode font

  • 1.  2D barcode font

    SILVER CONTRIBUTOR
    Posted 09-13-2018 12:57 PM
    ​Hello community!
    I am looking to download a 2D barcode font for a crystal report. Does anyone have a good website they have used and any instructions to get this into the report?
    Thank you!

    ------------------------------
    Jenn Morton
    Manufacturing Consultant
    Sabre Limited
    Cambridge Ontario Canada
    ------------------------------


  • 2.  RE: 2D barcode font

    TOP CONTRIBUTOR
    Posted 09-13-2018 02:19 PM
    One that I've used successfully in the past is Free3of9.  A free font from http://www.free-barcode-font.com/. Not sure if it works with Crystal, but I used it with NAV.  Just remember that the font must be installed on the PC which is controlling the print.  The report must also reference the font name within the report definition to find the right font.

    ------------------------------
    David Wiser
    Project Manager/Solution Architect
    Beck Consulting
    Kent WA
    ------------------------------



  • 3.  RE: 2D barcode font

    Posted 09-14-2018 08:14 AM
    I will second David's suggestion. I have used the Free3of9 in a few ways in NAV, excel, word via mailmerge and has worked with all of them. I cannot speak specifically to Crystal Reports. If you use it be sure to follow the instructions in the link David provided and include an asterisk before and after the value or the barcode will not scan.

    ------------------------------
    Jonathan Kleist
    NAV Administrator
    Gustavo Preston
    Chelmsford, MA
    ------------------------------



  • 4.  RE: 2D barcode font

    GOLD CONTRIBUTOR
    Posted 09-14-2018 08:10 AM
    I'll second that vote for 3 of 9. If you try to use a more-complicated barcode such as Code128, then you get into having to write some difficult code to generate checksum digits. With Code 3 of 9, the barcode is just the string you want to print.

    I've used this font with NAV before for customers, and it is free:

    https://www.fontsupply.com/fonts/F/Fre3of9x.html?fn=Fre3of9x

    Install that font on each workstation that will print from Crystal Reports. Change the barcode field in your report to use the Free 3 of 9 font, and you'll probably have to increase the font size 24 or larger.

    You will need to add an asterisk at the beginning and end of the string - that lets the barcode reader know when to start and stop.

    As for testing, you can either use an App on your phone, or you can buy a cheap barcode reader. I use an app called SCANDIT on my iPhone, but I also have this barcode reader for testing. $20. Works well for printed samples; does not work scanning a PC screen, but the iPhone app does.

    WoneNice WN3300
    https://smile.amazon.com/WoneNice-Barcode-Scanner-Handheld-Reader/dp/B00LE5VV1C/ref=sr_1_sc_2?ie=UTF8&qid=1536925426&sr=8-2-spell&keywords=wone+nice+wn3300

    It acts like a keyboard. Connect it to your PC, then run Notepad. Scan a barcode, and it should "type" the results into Notepad.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Atlanta GA
    ------------------------------



  • 5.  RE: 2D barcode font

    TOP CONTRIBUTOR
    Posted 09-14-2018 09:16 AM
    I actually have used the Free 3of9 barcode with Crystal reports as well and it works fine. So, I would suggest to start there and try if that works for you. Then, as Kyle suggested you can try Code128 if you want a more complicated and narrow barcode.

    ------------------------------
    Meenakshi Singh
    Manager of Business Applications
    Home Market Foods, Inc.
    Norwood MA
    ------------------------------



  • 6.  RE: 2D barcode font

    TOP CONTRIBUTOR
    Posted 09-15-2018 01:11 PM
    There are two parts to a 2D barcode. The encoder and the font. It would be difficult and expensive to get a 2D barcode to work with most reporting tools.

    A better option would be to use BarTender automation. The number of users is unlimited, but pricing is based on the number of printers. The have 3 printer editions, 10 printer editions etc.

    No solution for 2D barcode printing is cheap, but this is the best option I have found.

    ------------------------------
    Gregory Alford
    ERP Manager
    Tri Star Metals LLC
    Carol Stream IL
    ------------------------------



  • 7.  RE: 2D barcode font

    TOP CONTRIBUTOR
    Posted 09-17-2018 09:48 AM
    I agree with both free3of9 for 1D single line barcodes.  The data in the field is what you get on the barcode.  Easy to see and understand.

    I also agree with Gregory on BarTender software.  When you need more robust control on the labeling and barcoding, interfacing with a label format software such as BarTender will make your life easier.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    Carmel IN
    ------------------------------