Barcode printing in Report

shivaprasad263
shivaprasad263 Member Posts: 70
edited 2007-07-23 in NAV/Navision Classic Client
hi Experts,

I have to show the barcode in report based on the item. I have taken new textbox with source expression as '*'+"Item"."No."+'*' . And I changed the font as 39251. The process , what I am doing is it correct ? . Can any body give me your valuable suggestions.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    othr than "item" not needing quotes and changing the font to barcode3of9 it should work - don't forget to expand the text box to a half decent size.

    the barcode font needs to be installed on all machines that will print this report.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • shivaprasad263
    shivaprasad263 Member Posts: 70
    Savatage wrote:
    othr than "item" not needing quotes and changing the font to barcode3of9 it should work - don't forget to expand the text box to a half decent size.

    the barcode font needs to be installed on all machines that will print this report.



    ok, I have changed the source Expression as Ite."No." and changed the font to barcode3of9 . when I run the report it not showing the barcode, instead it showing the item itself, It means whether I have to install the barcode fonts. If so can u pls, tell me how should I get those fonts.
  • nunomaia
    nunomaia Member Posts: 1,153
    In partnersource there are TTF fonts of barcode.

    https://mbs.microsoft.com/knowledgebase ... UKKYXKSWLK
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ajhvdb
    ajhvdb Member Posts: 672
    Which font uses 128B and with which checksum?
    Create dynamic Excel or Word documents, ReportX
  • Savatage
    Savatage Member Posts: 7,142
    ajhvdb wrote:
    Which font uses 128B and with which checksum?

    Happy day for you :D
    http://www.mibuso.com/dlinfo.asp?FileID=405
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • aka_USAPA
    aka_USAPA Member Posts: 62
    nunomaia wrote:
    In partnersource there are TTF fonts of barcode.

    https://mbs.microsoft.com/knowledgebase ... UKKYXKSWLK

    What is the exact font name that I type in the fontname property? Does this work for 4.0? I've downloaded the fonts, I know it works because I've used the fonts in Word, and it works. How do I get that to work with Navision?
    Another way: http://yourfuture.myshaklee.com
  • nunomaia
    nunomaia Member Posts: 1,153
    I use in reports font name "Code39 TT"
    It works without any problems.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • aka_USAPA
    aka_USAPA Member Posts: 62
    nunomaia wrote:
    I use in reports font name "Code39 TT"
    It works without any problems.

    I tried that, it still does not work. I guess I'm not convinced that "Code39 TT" is part of the fonts I downloaded from earlier in this thread. Any ideas?
    Another way: http://yourfuture.myshaklee.com
  • Savatage
    Savatage Member Posts: 7,142
    The Font name I Use is "BC C39 3 to 1 Narrow"

    Start->Control Panel->Fonts Should give you the name you need

    Here are some more barcode fonts
    http://savatage99.googlepages.com/BarcodeFonts.zip
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • gulamdastagir
    gulamdastagir Member Posts: 411
    Savatage wrote:
    othr than "item" not needing quotes and changing the font to barcode3of9 it should work - don't forget to expand the text box to a half decent size.

    the barcode font needs to be installed on all machines that will print this report.

    I tried using a symbol scanner to scan this barcode, didnt work!

    could there be a use of barcode when u cant scan it?
    Regards,

    GD
  • nunomaia
    nunomaia Member Posts: 1,153
    don't forget that barcode 39 needs '*' before and after code

    sample

    * + value + *
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • gulamdastagir
    gulamdastagir Member Posts: 411
    ok i see the stars '*' before and after the code thats what makes the scanner to scan the barcode.

    thanks \:D/
    Regards,

    GD
  • aka_USAPA
    aka_USAPA Member Posts: 62
    Savatage wrote:
    The Font name I Use is "BC C39 3 to 1 Narrow"

    Start->Control Panel->Fonts Should give you the name you need

    Here are some more barcode fonts
    http://savatage99.googlepages.com/BarcodeFonts.zip

    Thank you very much, kind Sir! :D
    Another way: http://yourfuture.myshaklee.com
  • Savatage
    Savatage Member Posts: 7,142
    Can I assume {Solved} ? :D
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • aka_USAPA
    aka_USAPA Member Posts: 62
    Savatage wrote:
    Can I assume {Solved} ? :D

    Printing of the barcode is. I do have another situation on the same project. We are implementing scanners for 19 plants all over the US for the first time. After some ardous and painful battling, I lost the arguement that we should go online with the scanners and certain aspects propelled us to go batch mode on our scanners. I'm using PSC 4410 Falcon scanners. It is using Word mobile as the storage media for the data collected. I want to print as a bar code the following:

    '*' + "Document No." + ',' + FORMAT("Line No.") + '*'

    The '*' is necessary for my scanner to read the barcode since i'm using 3 of 9. However, when I put the above in the source expression of the text object, my scanner comes up with a different output.

    Any ideas?
    Another way: http://yourfuture.myshaklee.com
  • Savatage
    Savatage Member Posts: 7,142
    What is the output?

    Why Format the Line #?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • aka_USAPA
    aka_USAPA Member Posts: 62
    Savatage wrote:
    What is the output?

    Why Format the Line #?

    I'm not sure I follow the questions. The output is some stuff I have no clue about... It doesn't make sense.

    As far as why format the Line No., that is so that I can use a text type source expression and an integer expression in one SourceExpress property. Code + Text + Integer won't work so the function format is necessary.
    Another way: http://yourfuture.myshaklee.com
  • Savatage
    Savatage Member Posts: 7,142
    '*' + "Document No." + ',' + FORMAT("Line No.") + '*'

    If your Doc # is ABC123 and Line # is 10000
    you want your result to be ABC123,10000???
    What I meant by what is the output....
    Open Notepad - Scan your barcode and see what the result is that appears in notepad.

    Also, Does it need to be combined? How about 2 seperate textboxes?
    1) '*'+"Document No."+'*'
    2) '*'+"Line No."+'*'
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • lockwc
    lockwc Member Posts: 8
    nunomaia wrote:
    don't forget that barcode 39 needs '*' before and after code

    sample

    * + value + *

    Hi,

    am also facing the same problem in NAV 40.

    How do you put in the * in the code??

    I tried inthe source exp but it is not allowed.

    Example: In the print Bar code field of the report, i defined the font using barcode30f9 TT, and in the source expression below i set up as
    *"Cross-Reference No."*.

    However, am getting an error. Help??? :oops:

    Thanks
  • lockwc
    lockwc Member Posts: 8
    lockwc wrote:
    nunomaia wrote:
    don't forget that barcode 39 needs '*' before and after code

    sample

    * + value + *

    Hi,

    am also facing the same problem in NAV 40.

    How do you put in the * in the code??

    I tried inthe source exp but it is not allowed.

    Example: In the print Bar code field of the report, i defined the font using barcode30f9 TT, and in the source expression below i set up as
    *"Cross-Reference No."*.

    However, am getting an error. Help??? :oops:

    Thanks


    Ok, issue resolved. Finally found out the problem - due to the *.

    Thanks everybody.
  • Savatage
    Savatage Member Posts: 7,142
    See a couple of posts above
    These are working source expressions
    1) '*'+"Document No."+'*'
    2) '*'+"Line No."+'*'
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • zzheng
    zzheng Member Posts: 30
    I have tried the barcode "Free 3 of 9 Extended', one of my computers showed the barcode, and everything was ok.
    But the other two computers didnot work, it didnot show the barcode, it showed the Item."No." itself, can anyone help me?
    thank you very much.
  • eYe
    eYe Member Posts: 169
    There is a free Code39 with sample code in Office and VB at
    http://www.idautomation.com

    It works great with NAV. Tested it with a Symbol scanner.

    :!: Make sure to check the EULA :!:
    Kind Regards,
    Ewald Venter

Categories