locked
is there an off the shelf bar code tool for ssrs RRS feed

  • Question

  • hi we run 2016 enterprise.  i looked for bar code functionality on the web and see only 3rd party products .

    is there a built in bar code capability in ssrs?

    Friday, August 7, 2020 5:25 PM

All replies

  • is there a built in bar code capability in ssrs?
    Only if you use a bar code font.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, August 7, 2020 6:17 PM
  • Hi,

    There is no built-in barcode capability in ssrs.

    We can install third-party Barcode font to render a barcode in the reports.

    To use barcode font in a report, please follow these steps:

    1.Install a barcode font on both the server and client by copying the font to C:\Windows\Fonts

    2. In report designer, select the textbox which is used to display Barcode, and then change the FontFamily to be the Barcode font we installed before.

    Here is a Free Barcode font for reference:

    https://www.barcodesinc.com/free-barcode-font/

    If the barcode fonts don't work in runtime, you could also try this way.

    https://www.codeproject.com/Articles/789254/How-to-Embed-Barcodes-in-Your-SSRS-Report



    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Proposed as answer by Zoehui-MSFT Friday, August 14, 2020 1:25 AM
    Monday, August 10, 2020 3:10 AM
  • thx olaf, does a barcode font come with ssrs?  zoehui seems to be suggesting no below.
    Monday, August 10, 2020 4:02 PM
  • thx zoehui, the first sentence in your second link says this...

    The following excerpts will show how to successfully embed barcodes in your SSRS reports (similar to Crystal Reports but somewhat different). Using Barcode fonts is nice, however they won't work on the reports published on the SSRS Reports server. 

    so does that diminish your first suggestion?  and how could using fonts be nice if they dont work?

    also, i'm in ssdt right now and would be happy if your second link's instructions would work there first, even before i deploy. 

    my understanding of the various sql stack items when it comes to vs2017 is that a mini version of the stack item is essentially running under ssdt, in this case ssrs.  so how do the target directories mentioned in that 2nd link map to a development scenario where vs2017 and ssrs are partnering for a report development scenrio?  can the  the community help me to tailor the recipe at your second link to a vs2017 rdl development effort?

    • Edited by db042190 Monday, August 10, 2020 4:16 PM afterthought
    Monday, August 10, 2020 4:06 PM
  • Hi,

    I could only look for 3rd documents for your reference cause there is no built-in barcode capability in SSRS officially.

    I have also found another documentation, you may have a try. 

    https://www.technoriversoft.com/barcode_reporting_services.html

    Here is also a Code 39 font for you.

    http://en.wikipedia.org/wiki/Code_39

    Microsoft  provides a channel for user feedback.

    You can directly reflect the current needs to the product group through the site below, and they will consider optimizing the product according to the user's support data.

    https://feedback.azure.com/forums/34192--general-feedback

    Regards,

    Zoe


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Tuesday, August 11, 2020 8:00 AM
  • to expound on Zoehui 's and olaf's posts, it doesnt matter if the barcode is installed on the ssrs server.  they must be found on the client making the request to the server.  so in our case, after we publish we have only 2 options.  every user has barcodes installed on their pc where the browser is running or we embed barcode fonts (i hate to go down that road)  in every report tha tneeds them per the link provided by zoehui earlier.  so its not "if that doesnt  work", its if all your users or client apps dont have them installed....
    Friday, August 21, 2020 4:11 PM
  • Thanks for db042190's supplement and summary, remember to mark as answer so we could achieve the case.

    Have a nice day!:-)


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Monday, August 24, 2020 1:39 AM
  • You can only use the bar code font
    Monday, August 24, 2020 4:44 AM
  • hi

    use code 128 for bar code or same like that .the bellow link may help you

    https://barcodewiz.com/user-manual/code-128-fonts/barcodes_in_ssrs_report_server.aspx

    Thanks and regards

    Monday, August 24, 2020 3:50 PM