need help adding barcodes to a crystal report

[kranmar]

I have a working crystal report and have barcode fonts. I have alphanumeric fields in my report and need help in converting an alphanumeric field using a code39 barcode. Can someone offer assistance?

 

[dgillz]

Look under additional functions in the formula editor. Do you see any functions that appear to do this?

In mine I have stringtocode39().

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[kranmar]

I appreciate the suggestion, unfortunately I installed azalea's software and barcode fonts and I am using crystal 11. Under additional functions I don't have stringtocode39(). What I do have is Barcode39Ascii() which when I enter a db field within the parentheses will print a barcode but when I scan it in with a barcode scanner it returns text with a + between letters. If I use the function Barcode39() with a db field within the parentheses it doesn't return any barcodes.

 

[dgillz]

Did you format the field as well? The ly the formula is only the first step.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[kranmar]

After I added the formula Barcode39Ascii() and added my db field after saving it I went to format the field and selected Code39WideI for the font. I guess my real question/problem is that after I print out the report and scan that field with a barcode scanner it displays with all the alpha characters but with a + symbol between each letter.

 

[dgillz]

What if you don't use the formula and just format the raw value? How does it scan then?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[kranmar]

If I format the field without a formula although it prints the barcode it won't scan in at all. Going back to where I can scan in some barcodes when using a formula and setting the font, when scanning in a name in a db field that contains a char value like Barker what appears when scanned to a document is B+A+R+K+E+R

 

[dgillz]

Maybe this is OK? I used a couple of barcode39 functions and they are all turning out like that.

Any barcode experts out there?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[lbass]

Maybe this BO technical paper would be helpful:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr_barcodes.pdf

-LB

 

[kranmar]

Thanks for the Business Objects document but I had already looked thru it and still can't get my crystal barcodes to scan in with a + symbol between letters. Any other ideas would be greatly appreciated.

 

[kranmar]

I finally got it to scan and print without the plus + sign between characters. I had to reprogram my scanner to "Enable Code 39 Full ASCII". Sorry for wasting everyones time. Anyway my barcodes in Crystal Reports are working now.