Streaming Barcode Images into SQL Server Reporting Service (SSRS)

This document explains how to stream barcodes Images into SQL Server Reporting Service (SSRS) report documents. Reporting Service report designers can generate and print barcodes in your reports without installing any barcode generation components and barcode fonts.

Here we are using OnBarcode Online Barcode Generator Hosting Service and ASP.NET Barcode Generator Web Application to stream barcodes into your Reporting Service reports.

If you are generating large number of barcodes in a single report, the latency will slow down to preview or generate reports.

We recommend you use Barcode Generator Custom Report Item (CRI) for Reporting Service to generate barcodes in your reports.

We provides several methods to generate and print barcodes in SQL Server Reporting Service. Please read our SQL Server Reporting Service Barcode Integration Guide for more information.  

1. Start Visual Studio, and create a new project. In "New Project" dialog,
   • Select "Business Intelligence Projects" as project type
   • Select "Report Server Project Wizard" as template
   • Use the default name "Report Project1" as report name
   
   
   
2. Click "Next" in Report Wizard dialog.
   
   
3. Select Data Source. We are using "AdventureWorks" as our data source. Click Next.
   
   
   
4. Create Query string. Copy "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer WHERE CustomerID < 20" to the Query string input box.
   
   
   
5. Select "Tabular" as report type.
   
   
6. Use the default settings in "Design the Table" Dialog, and click Next.
   
   
7. Use the default settings in "Choose the Table Style" Dialog, and click Next.
   
   
8. Use the default settings in "Choose the Deployment Location" Dialog, and click Next.
   
   
9. Name the report "Stream Barcode in Reporting Service", Click Finish.
   
   
10. Add a new column to your report to display barcodes. In this example, we will use Code128 to encode Customer Account number.
    • Right click the table in the report, select "Insert Column to the Right"
    • Keyin "Barcode" as column header
    • Select the Column "Barcode". We need print and draw barcodes to background image of the "Barcode" column
    • In BackgroundImage proporty:
      
      Choose Source as: External
      Choose Value as: ="http://azuredemo.onbarcode.com/linear.aspx?TYPE=7&DATA=" + Fields!AccountNumber.Value
      Choose MIMEType as: image/gif
      Choose BackgroundRepeat as: NoRepeat
    
    
    
    
11. Click "Preview" tab to view the generated report.