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.  

How to generate & print barcodes in your SQL Server Reporting Service (SSRS)?

  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: ="" + Fields!AccountNumber.Value
      Choose MIMEType as: image/gif
      Choose BackgroundRepeat as: NoRepeat

  11. Click "Preview" tab to view the generated report.

OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © . All rights reserved.