IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FL Contact IDAutomationView your cart in the IDAutomation Store  
Loading
Home > Barcode Components > ASPX Generator Script > Streaming Barcodes in Microsoft Report Builder

Streaming Barcode Images in Microsoft Report Builder

In this tutorial, the IDAutomation ASPX Generator Script is used to stream linear barcodes in Report Builder, which is a report authoring tool included with Microsoft SQL Server and SSRS (SQL Server Reporting Services). This example uses the free version of the ASPX Barcode Generator Script, which contains a watermark at the bottom of the barcode symbol. The purchased version of the script does not contain the watermark.

Order the ASPX Barcode Generator ScriptDownload the ASPX Barcode Generator Script Forum Support for ASPX Barcode Generator

Overview

Barcodes can be easily implemented in a report by placing the IDAutomation Generator Script URL into a Text Box value and setting the URL parameter to a desired field. When the report is run, barcode images are streamed into the report.

Report Builder Exmaple

Report Builder Barcode Tutorial

Applications used in this Tutorial:
Tutorial

NOTE: The tutorial assumes Report Builder is properly installed and that the Barcode Generator Script is implemented and functioning. Within this tutorial, the free version of the ASPX Generator Script is used.

  1. To run Report Builder, double-click the application icon.
    Report Builder Icon
  2. To create a new report, select New Report and then select Table or Matrix Wizard.
  3. Select Create a dataset and choose Next.
    Create a new Dataset
  4. For Data Source Connections, select New.
  5. In the Data Source Properties, select a Name, choose a connection type, and select Build.
  6. In the Connection Properties, select the Server name, and the database. In the example, the database name is Barcode. Select OK.
    Create Database Name
  7. The Connection string should include the Server name and database. To verify the connection, select Test Connection. If the connection string is successful, a 'Connection Created Successfully' message will appear. Select OK.
  8. Once the Test connection is linked, select Next.
  9. The Design a query allows the user to select fields for the report.
    Select Fields for the Report
  10. To view or edit the query, select Edit as Text. If the report does not need a query edit, select Next.
  11. Choose the fields that will appear on the report. Select Next.
  12. Choose a layout for the report.
  13. Choose a style for the report.
  14. To view the report, select the Run button near the top left corner of the application.
    Run the report

    Report View:
    Report View
  15. To return to design mode, select Design.
    Return to Design Mode
  16. Choose Insert - Text Box.
    Insert Text Box
  17. Drag the Text Box to the report and place it within the field area. In the example, the Text Box is placed underneath the Number field.
    Drag Text Box to Report
  18. In the Text Box properties, expand the BackgroundImage and complete the following steps:
     
    • Set the Source to External.
    • Set the Value to the Generator Script and append the desired field.
      The example uses the ASPX Generator Script and sets the DataToEncode (parameter D) to the Number field:  ="http://www.bcgen.com/aspxscripts/idautomation-code128.aspx?D=" & Fields!Number.Value
    • A MIMEType image setting is not required.
    • Set the BackgroundRepeat to RepeatY.
      Setting Text Properties for Barcode URL
  19. Save the report.
  20. Run the report. If the Text Box does not display the full barcode in report view, return to design mode and adjust field height and width.
  21. This example uses the free version of the ASPX Barcode Generator Script, which contains a watermark at the bottom of the barcode symbol. The purchased version of the script does not contain the watermark.
    Barcode on Report

 If a scanner is needed, consider purchasing the IDAutomation USB Barcode Scanner.

Back to Top

 © Copyright 2014 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus 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.