Creating a barcode from a db field

[maddmikk]

Hi all, I use report builder with an old erp system and am wondering how I can get an embedded field turned into a scannable barcode font. Currently I want to use 3of9 extended and I need somehow to add a *% in front of and behind this field result. If I try and add these characters i get a syntax error. Do I need a formula to add what I need?Please advise and thanks in advance.

the field co_customer_po_ref_no calls data from the db

gupta.jpg

[MSchmidt]

try:

If the item is a char field:
'%'||CO_CUSTOMER_PRO_REF_NO || '%'


If the item is a number field:
'%'||NumberToStr( CO_CUSTOMER_PRO_REF_NO,0) || '%'


hope this can help

regards
M.Schmidt

[cindy313]

it's according to the type of item you wanna add
hope this helps
http://www.ciax.com/manuals/jitdbc/generating.htm

[taltoscsiko]

try:

If the item is a char field:
'%'||CO_CUSTOMER_PRO_REF_NO || '%'


If the item is a number field:
'%'||NumberToStr( CO_CUSTOMER_PRO_REF_NO,0) || '%'


hope this can help

regards
M.Schmidt

Hi!

I tried the same solution, but when I print it out, I can't see the whole string.
For example: The data field contains 9 characters (IRE-12345). After adding a '*' to the beginning and the end of the string it should have the length of 11 (*IRE-12345*). But only 9 characters are printed out (*IRE-1234).
So how can I extend the original string length?

regards
R.F.

Update: I solved the problem with StrPad( '*'||Data_Field_X||'*' , 11). It just wasn't visible at first. Only after shutting down everything and starting it up again the changes took place.