Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bar Code Print from Crystal Reports

Status
Not open for further replies.

HMerchant

IS-IT--Management
Dec 30, 2003
3
US
IS there a way to print Bar Code (3 of 9) from item number data accessable via Crystal Reports?
 
You can download the font 3 of 9 (it is just like any other font).(i dont have much info about which website offers the download. You can always google.)
Put the item number onto your report. Now change the font to 3of9.
 
Be careful with some of the 'free' barcode fonts you find on the web, some do not translate all of the characters i.e. some only do numbers, some only do alphas. This is so you can evaluate them prior to purchasing them...

Also, you'll need to do more than simply 'add the item number onto your report and change the font to 3of9' if you ever plan to scan the barcode. Most barcodes require a start and end character to be wrapped around the actual value being scanned - in the case of 3of9 it's an asterix. So, you'll need to create a formula to concatenate an asterix to the start and end the barcode value.

Peter Shirley
 
How do you create a formula to add asterix to the barcode value? Thanks.
 
Is the barcode value a number or a string...?

NUMBER TO BARCODE
==================

"*" + Replace (Replace (ToText ({Table.Field}),"," ,"" ),".00" ,"" ) + "*"

STRING TO BARCODE
==================

"*" + {Table.Field} + "*
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top