Creating a barcode from a db field

Discussion forum about all things Report Builder (all versions).
maddmikk

Creating a barcode from a db field

Post by maddmikk » 31 Jan 2013, 15:13

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
You do not have the required permissions to view the files attached to this post.

MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

Re: Creating a barcode from a db field

Post by MSchmidt » 01 Feb 2013, 16:36

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

Re: Creating a barcode from a db field

Post by cindy313 » 18 Feb 2014, 04:08

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

taltoscsiko

Re: Creating a barcode from a db field

Post by taltoscsiko » 13 May 2015, 10:53

mschmidt wrote: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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ahrefs], [Ccbot] and 0 guests