Skip to Content

Reg: EAN 13 and GTIN barcodes

Hi Team,

We have developed WPF application and it includes crystal reports to develop the reporting. We are using multiple UPC format's like UPC, EAN and GTIN to represent the product.

As of now we are using only UPC of (12 digits) to print the barcodes on crystal reports using the UPC-A font by encoding the below logic.

Local StringVar pUPC := ({UPCData.upcNo});
Chrw(Ascw(mid(pUPC,1,1))+32)+
Chr(Asc(mid(pUPC,2,1)))+
Chr(Asc(mid(pUPC,3,1)))+
Chr(Asc(mid(pUPC,4,1)))+
Chr(Asc(mid(pUPC,5,1)))+
Chr(Asc(mid(pUPC,6,1)))+
Chr(112)+
Chr(Asc(mid(pUPC,7,1))+16)+
Chr(Asc(mid(pUPC,8,1))+16)+
Chr(Asc(mid(pUPC,9,1))+16)+
Chr(Asc(mid(pUPC,10,1))+16)+
Chr(Asc(mid(pUPC,11,1))+16)+
Chr(Asc(mid(pUPC,12,1))+48)

We are able to print the barcodes and are able to scan the customers for UPC(of 12 digits). But if customer uses EAN-13 and GTIN-14 as upc format, how can we encode the EAN-13(numeric string that includes checksum digit) to print as barcode in crystal report using the UPC-A(Barcode font). We have few third party dll's which is converting the value to barcode image but we need to develop this logic in crystal reports only in formula fields. Please help us from getrid of this issue.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 16, 2017 at 08:48 PM

    Ask the UFL's developers to support multiple encoding formats.

    OR prompt the users for the format and use logic to set them in your formula.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Don,

      We have done the changes and tested as like above formula but dint work. If you have any idea please let me know. Thank you for the update.

      Thanks,

      Chakradhar

  • Oct 16, 2017 at 08:50 PM

    Hi,

    You'll have to create a formula similar to the one you posted. I did a quick Google search on EAN-13 and found this page that describes the formatting.

    https://boxshot.com/barcode/barcodes/ean-13/

    You'll also need to download and install a EAN-13 barcode font. There may be a utility available for you to use but I didn't go that far into my search.

    Good luck,
    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2017 at 10:04 AM

    EAN-13 and UPC-A are different barcodes.

    At least one of the 3rd-party UFL's listed here allows you to generate both types (as well as 14 other types) using a simple Crystal report formula. The image is generated on the fly and the path to it set as the 'Graphic Location' expression of a picture object. This means there's no dependency on font files. Here's a sample image showing 6 different barcode types rendered on a Crystal report.

    Add comment
    10|10000 characters needed characters exceeded