Is it possible to create a bar code in SQL reporting?

I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.

< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> 

Thanks



Answer this question

Is it possible to create a bar code in SQL reporting?

  • suedueno

    As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.

    So what exactly is the fix. Was one ever found


  • ShadowWolf

    Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.

    In Crystal, I had to put an * before after the value.

    In Excel, it works the same way.

    But in SRS 2000, it will not work.

    My expression is

    ="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"

    I have also tried using the plus instead of *.

    The font I am using is Free 3 of 9 Extended.

    thanks for you help.


  • Agent00

    SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.
    When you've got the font then replace the font of the field wich has the code and that's all.
    Good luck in your search.

  • AlexCode

    I found a better choice instead of using fonts.

    < xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> 

    Barcode Professional .NET for Reporting Services

    http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx tabid=78&prodid=7

    Cheers


  • foxjazz2

    Or you could try this Windows Form Control that supports Reporting Services.

    http://www.technoriversoft.com/developer.html


  • Daxel

    thanks
  • Midget01

    IT is not good way

    it is because when you compile the report into production server.

    when user print it, it will show the text rather than bar code....


  • Is it possible to create a bar code in SQL reporting?