A customer recently wanted to convert an employee ID number into a barcode in his crystal reports. With that request, we that set out to locate a font to use. In this case, Code 39. Much to our surprise, we found that the cost of a font ranged from $50.00 to $300.00. With the magic of google and five minutes of our time, we where able to locate a number of freeware versions. *I’ll add the disclaimer that I don’t know what you get extra when your purchase a font from a company.*
The below fonts will work with Crystal Reports or any Windows or Mac program that supports TrueType fonts.
Using fonts within Crystal Reports:
1. Install the barcode font you wish to use on your workstation.
*NOTE: If you plan on running your report on a crystal reports / business objects enterprise server, you will need to install the font on the server.
2. From Crystal Reports, open or create the report you wish to add a barcode to.
3. Insert a Text Object into your report and enlarge it.
4. Insert into the Text Object the database table/view you wish to convert into a barcode, twice with a hard return in between, center the fields within the Text Object, and finally add an ‘*’ at the beginning and ending of the second field.
5. Double click on your Text Object and click on your first field to highlight it.
6. From the toolbar, select the font ‘Code128′ and set the font size to 36.
7. Refresh and Preview your report.