Barcode Fonts, Components, ActiveX and .NET Windows Forms Controls, Java Servlets, 
DLLs and Barcode Scanners.   IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FL View your cart in the IDAutomation Store    


SSRS Barcode Generator User Manual | Tutorial

Order the SSRS Barcode Generator Service Download the SSRS Barcode Generator Service View the release log for the SSRS Native Generator Forum Support for SSRS Barcode Generator

Overview

This product package includes both a Native Barcode Generator (which is embedded in the report and runs natively) and a Script Generator (which streams barcodes into reports from a server). IDAutomation recommends using the Native Generator unless the server side generator is specifically required. Below is a summary of each product:

Native Barcode Generator (Located in the "SSRS Native Generators" folder)

Server Side Script Generator (Located in the "IIS Server Side Script Generators" folder)

Native Generator Installation

IDAutomation recommends using the Native Generator over the Script Generator. This tutorial provides a walkthrough of steps for generating barcodes in SQL Server Report Builder or Visual Studio .NET Report Designer for Reporting Services.

Report Designer Compatibility:
Report Builder Compatibility:
Installation | Tutorial: 

The files for the Native Generators are located in the "SSRS Native Generators" folder of the product zip file. RDL files are also included as an example, which should be referred to if problems are encountered with implementation.

  1. Open the custom code section of the report:
    • Visual Studio .NET Report Designer users: The native generator can only be installed into existing reports. Refer to the Creating a Report tutorial, if there is not an existing report. Select File - New - Project. To activate the Report menu in the VS .NET IDE, click on the body of the report. Select Report - Report Properties - Code.
      Select Report - Report Properties - Code
    • Report builder users: Choose File - New - Report and open the report custom code. If the Report Properties dialog does not appear, click on the gray area of the report.
      Report custom code dialog
  2. The code area of the report should now appear:
    SSRS report custom code area
  3. Open the desired barcode type text file from the SSRS Barcode Generator download, such as IDAutomation SSRS Native - Code 128.txt.
  4. Copy the contents of the file and Paste the code into the custom code area and choose OK. This places a custom function in the report that can generate the barcode. Save the report.
    The Custom Code area of the Report Properties

  5. Add a Textbox where the barcode is needed or locate an existing text field and size it to be large enough to contain the barcode generated. If the Textbox is not large enough, the barcode will be very distorted. In order to produce the required quiet zone, or the space around the barcode, it is recommended to choose the paragraph center options.
    Centering and sizing the barcode field
  6. Right-click on the Textbox and select Expression. This is where the custom code is executed and the resulting barcode will be placed within the Textbox. In design mode, the expression will appear as «Expr» .
    The SSRS Expression
  7. Set the expression to include the barcode generation formula:
    =Code.IDAutomation_SSRS_Code128(Fields!HeroID.Value)
    replacing HeroID with the data that needs to be encoded in the barcode and select OK. To obtain the formula for other barcode types, refer to the example listed at the top of the associated .txt file.
    The barcode generation formula
  8. Select the field and set the font to Lucida Console (Data Matrix & QR Code use Courier New) at 4 points. The point size of 4 sets the X Dimension of linear barcodes to 16 mils and 2D barcodes to 24 mils. If a different X Dimension is needed, adjust the font point size accordingly from the chart below. Use 3 points for USPS IMb for 24 bars per inch. How to set unique point sizes
    NOTE: Ensure the report background is white and the font is black.

    Lucida Console font at 4 points
    Point Size X Dimension Notes about point size and symbol distortion
    2 08 Mils (.02cm)
    • Use 3 points for USPS IMb and 1.75 points for small DataBar symbols.
      How to set unique point sizes
    • When using a 203 dpi thermal printer the point size should be:
      For linear barcodes: 2.4, 4.8, 7.4 or 9.8.
      For 2D and DataBar: 1.75, 2.6, 5.25 or greater.
    • If distortion is noticed, slightly adjust the point size up or down in .1 point increments until a correct symbol is obtained. How to set unique point sizes
    • To scan from the screen of a Windows PC, the best sizes to use are 10, 12 or 16 points.
    • X dimensions are doubled for DataBar, Data Matrix and QR-Code. For example, a QR-Code printed at 5 points will have an X of 40 Mils.
    • X dimensions are approximate and may change with different resolutions of printers and screens.
    2.5 10 Mils (.025cm)
    3 12 Mils (.03cm)
    4 16 Mils (.04cm)
    5 20 Mils (.05cm)
    6 24 Mils (.06cm)
    7 28 Mils (.07cm)
    8 32 Mils (.08cm)
    9 36 Mils (.09cm)

  9. Save the file and Preview the report.
    SSRS Report Preview with Native Barcode

  10. To deploy Visual Studio .NET Report Designer solutions to the Report Server, select Build - Deploy Solution. For guidance about how to set up deployment, refer to Microsoft's How to Set Deployment Properties article.
Other Information

Native Generator Parameters

Parameters may be modified as necessary. Click the links of the following parameter properties list for more details.

Symbology Associated File Parameters (Defaults should be changed within the custom code)
Code-39 Code 39.txt DataToEncode, BarHeight, N_Dimension, IncludeCheckDigit
Code-128 Auto Code 128 Auto.txt DataToEncode, BarHeight, ApplyTilde
Code 128 A Code 128 A.txt DataToEncode, BarHeight
Code 128 B Code 128 B.txt DataToEncode, BarHeight
Code 128 C Code 128 C.txt DataToEncode, BarHeight
Interleaved 2-of-5 Interleaved 2 of 5.txt DataToEncode, BarHeight, N_Dimension, IncludeCheckDigit
Data Matrix Data Matrix.txt DataToEncode, ApplyTilde, EncodingMode, PreferredFormat
PDF417 PDF417.txt DataToEncode, ApplyTilde, ForceBinary, EccLevel, ColumnSpecify
QR Code QR Code.txt DataToEncode, ApplyTilde, EncodingMode, ErrorCorrectionLevel
USPS IMb USPS IMb.txt DataToEncode
GS1 DataBar GS1 DataBar.txt DataToEncode, BarHeight
GS1 DataBar Stacked GS1 DataBar Stacked.txt DataToEncode, BarHeight
GS1 DataBar Expanded GS1 DataBar Expanded.txt DataToEncode, BarHeight

Script Installation Tutorial

The server-side script adds barcode generation capability to SSRS by streaming barcodes into the report.

  1. Download the product file and copy the script files to an ASPX-enabled webserver such as IIS. Each file contains the name of the supported barcode symbology.
  2. Open the URL to the file in a browser window and verify that a default barcode appears, this will be your unique SSRS Generator URL. If a symbol does not appear, verify the files are installed in the proper folder on the server and confirm that ASPX script processing is active in the folder where the file resides.
  3. Use the unique SSRS Generator URL obtained above with the applicable Report Designer or Report Builder Tutorials.

The script is also available as a service hosted in IDAutomation's fault tolerant server cloud. The service is an easy way to generate barcodes without installing any software.

Script Parameters

Refer to the SSRS Barcode Generator Service for all parameters; they are the same parameters used in this product.

Creating a Report with Reporting Services

The following tutorial is a basic example of a report that can be created with Reporting Services. For additional information and examples, refer the Microsoft Reporting Services (SSRS) Tutorial and related documentation.

  1. Select File - New - Project.
  2. In the Templates, select Business Intelligence - Reporting Services - Report Server Project Wizard.
    The Reporting Services Report Server Project Wizard
  3. Name the project and select OK.
  4. In the Select the Data Source window, select New data source, create a Name, set the Type of data source, and choose Edit.
  5. In the Connection Properties, select the Server name; log onto the server; select or attach the database, and select OK.
    SQL Server Connection Properties
  6. To verify the connection is successful, select Test Connection. The test results should display Test connection succeeded. Choose OK and Select Next.
  7. In the Design the Query, select Query Builder.
    The Query Builder
  8. Select the Add Table icon..
    The Add Table icon
  9. Choose the Table and click Add. Select Close.
    SSRS Table Selection Dialog
  10. Place a checkmark in the box in front of the fields to include on the report and select OK.

  11. Once the query string is set, select Next.
  12. Select the report type and choose Next.
  13. In the Design the Table window, move the Available fields to the Displayed fields text area by left-clicking the field and select Details > Next.
  14. Choose the table style for the report and select Next.
  15. Set the Report Server Version, Report Server, Deployment Folder, and choose Next.
  16. Create a name for the report and choose Finish to complete the wizard..
    SQL Report Name Result

Technical Support Issues

Forum Support for SSRS Barcode Generator
View the release log for the SSRS Native Generator
Native Generator Related Issues:

Additional Support Methods

Script Related Issues:
Barcode Image not Generating:
Forum Support for SSRS Barcode Generator
View the release log for the SSRS Native Generator

Open the System Status Site and verify the barcode generators and all operational. The service may be tested by accessing the barcode URL directly. For example, https://www.bcgen.com/ssrs/demo-c128.aspx should create a default barcode image.

Slow Performance when Generating Multiple Barcodes:
If a large number of barcodes are generated from the same system at the same time, some latency may be noticed. If this is an issue, consider installing the SSRS Generator Script locally or on an Intranet. Performance over multiple clients should not be an issue. A performance test performed in 2017 shows an average response time of 33 ms for 2000 clients requesting barcodes during business hours.

The purchased version of this product does not contain a watermark. If it is desired to have a watermark in the purchased version, the demo portion of code may be edited to enable this feature with a text message. For example:
Const Demo as Boolean = True
Const DemoText as String = "My Message"

Additional Support:

Back to Top

 ©Copyright 2019 IDAutomation.com, All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us

Training Videos on YouTube  Join us on LinkedIn  Follow us on Twitter  Like us on Facebook
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.