Decimal (or Number) field to text using barcode39

[ramjones]

I was able to setup barcode 39 font (azalea.com) in Crystal report (Pro 8.5) for Packlist ID, PO #, and Part Number. My problem is Quantity and I originally created this:
BarcodeC39({SHIPPER_LINE.USER_SHIPPED_QTY})
and when I hit 'Save', error message appeared "A string is required here." So I modified it to this:
BarcodeC39(ToText ({SHIPPER_LINE.USER_SHIPPED_QTY}))
It took it but the scanner is not picking it up. Then I contacted azalea's tech support and they suggested this: ToText({your.Number}, 0, "", "") and when I hit 'Save', error message appeared "Too many arguments have been given to this function." I haven't heard back from them. Then I'd thought to give this forum a try. Thx. Tina

 

[synapsevampire]

Use:

ToText({your.Number},0,"")

Or if they want a comma, which I doubt, use:

ToText({your.Number},0,",")

-k

 

[ramjones]

Those don't work, gave me same error message. Been on this for two days and I finally got it using this: BarcodeC39(Trim (ToText ({SHIPPER_LINE.USER_SHIPPED_QTY},0)))

Thanks for your time helping me out. I appreciate it a great deal.

 

[towntopic]

I think the easiest way to convert fields into a barcode font is to simply set up a formula like this.


"*"+{yourfield.here}+"*"

Then you just format your fields for using the bc3o9 font. We do this everywhere on our reports - manufacturing industry.

Cheers.