Reg: EAN 13 and GTIN barcodes

[Former Member]

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.

[ido_millet]

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.

[former_member292966]

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

[Former Member]

Hi Brian,

Thank you for the update. We have installed the EAN 13 barcode font and applied on the EAN string but it dint work. We want to know the encoding logic in crystal report to support with EAN 13 barcode font. We want to know the formula which is using in crystal report itself to encode the EAN-13 value.

Please let us know if you have any ideas.

Thanks,

Chakradhar.

[former_member292966]

Hi Chakradhar,

Unfortunately, I don't know the formatting of the EAN string. That would be something you'll have to research more on.

Sorry,

Brian

[former_member11696]

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.

[Former Member]

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