Azalea Software, Inc. www.azalea.com Print UPC Barcodes in Crystal Reports UPC in Crystal Reports

When you need to print brcodes in your Crystal Reports report, your simplest choice is to use Azalea’s free User Function Library (UFL) along with our TrueType UPC fonts. Our UFL will make a scannable UPC, EAN, JAN, and ISBN-13 barcode by appending start and stop bars to your input string, calculating the necessary check digit(s), and then mapping output into our fonts’ character set. You will want to use our UPC UFL because you can not simply format a chunk of text in a barcode font and create a scannable UPC bar code symbol. The UFL does all of the heavy lifting for you.

1. As long as you followed the default install in UPCTools for Windows, the installer will install the files you need to use the fonts with Crystal Reports. You just need to open the Crystal Reports file with the information you need to make into barcodes.

2. In your Field Explorer in Crystal Reports, make a new formula.

Insert a new formula

3. Give your formula a name.

Name your formula

4. Double-click the BarcodeUPCA function name (or other listed UPC supported function name then double-click on your field name.

Note: if you making a UPC or EAN barcode without supplemental bars, add double quotes to your function. (BarcodeUPCA({Mytable.MyField}, "")

Choose a function

5. Choose Save and Exit from the formula editor.

Enter a database field name

6. Format the field in one of Azalea’s UPC barcode fonts. In this example, we’ll use UPCTall at 72 points.

Select formula name

7.You’re ready to run your report with integrated UPC or EAN/JAN barcodes!

Select formula name

8. Once you’re ready to print your barcodes, choose “print” and send your report to a local printer as usual. If the output result differs or you see boxes or odd characters, please send a screenshot to technicalsupport at azalea dot com and we’ll be happy to help you get it sorted out.

Need help? Email us at azalea at azalea dot com or call 1.206.341.9500