How to Create QR-Code Barcodes in SQL Server Reporting Services (SSRS Reports)
Mature .NET barcode generator for SQL Server Reporting Services
Written in Visual C# code with full compatibility for .NET Framework 2.0 and above
Support easy deployment and installation for .NET barcode libraries for SSRS
Simple to generate QR Code barcode images in .NET SQL Server Reporting Services
Support multiple QR Code barcode properties adjustment like module size, margin, version & ECL
Generate highly readable QR Code barcodes in Png, Jpeg, Gif and Bmp image formats
Easy to print QR Code barcodes in bulk with data from database
Feel free to choose from royalty-free developer licenses for commercial use
Reporting Services QR Code Barcode Introduction
QR-Code is a two-dimensional / 2D symbology developed by Denso Wave. It is also known as Quick Response Code, Denso Barcode, QRCode, JIS X 0510, ISO/IEC 18004.
Compatibility: Barcode for Reporting Services dll is compatible with ISO/IEC 18004 (Second Edition 2006-09-01) bar code symbology specification for QR Code printing.
We have provided one demo data file named "BarcodeDemoData.mdb" in our trial package. In the following steps, we will config ODBC driver for that data file.
Open "Control Panel". Go to "Start", and click menu "Control Panel".
Click "Administrative Tools".
Click "Data Sources (ODBC)".
In "ODBC Data Source Administrator", click tab "System DSN".
Click button "Add..." on the right side of the form. view image
In "Create New Data Source" form, select "Driver do Microsoft Access (*.mdb)", and click "Finish" button. view image
In "ODBC Microsoft Access Setup" form, fill "Data Source Name" as "BarcodeDataSource", then click "Select..." button. view image
In "Select Database" form, go to your downloaded package, and select "BarcodeDemoData.mdb" file, and click "OK" button. view image
In "ODBC Microsoft Access Setup" form, click "OK" button.
Now you can find new entry in "System Data Sources: " section. view image
Click "OK" button to close it.
How to Deploy and Install QR-Code SSRS Barcode Library
Copy BarcodeLib.Barcode.ReportingService05.dll, BarcodeLib.Barcode.ReportingService05CRI.dll to Visual Studio private assemblies directory (by default C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies).
Copy BarcodeLib.Barcode.ReportingService05.dll, BarcodeLib.Barcode.ReportingService05CRI.dll to Microsoft SQL Server Reporting Services bin directory (by default C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin).
Edit rsreportserver.config file under "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer".
Edit rssrvpolicy.config under the same folder with rsreportserver.config.
Edit rsreportdesigner.config under "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies".
How to Generate QR Code barcode in Reporting Services 2005 / 2008?
This is a simple sample for you to create QR Code in Reporting Service 2005.
Create a report: Select File | New | Project from the Visual Studio .NET 2005 IDE menu. In the New Project dialog, highlight Business Intelligence Projects in the Project Types box and Report Server Project Wizard in the Templates box. Name the sample report appropriately in the Name box. Click OK. view image
In "Report Wizard" form, keyin name as "BarcodeDemoData", select type as "ODBC", and click "Edit.." button. view image
In "Connection Properties" form, select "use user or system data source name:" as "BarcodeDataSource", and click "OK" button. view image
In "Report Wizard" form, click "Next" button.
Type in "SELECT * FROM Customer;" in "Query String:" field. Click "Next". view image
Select report type form, select "Tabular" as default. Click "Finish".
In report designer panel, add a new column "Barcode" to the table, by right click column "Customer" header, and select "Insert Column to the right" menu. view image
For the new column "Barcode", set name as "Barcode". Add Reporting Services Barcode Controls to Toolbox and drop "LinearBarcodeControl2005" to the data section. view image
Set "BarcodeData" property to "=Fields!CustomerId.Value". view image
You can preview the report by click "Preview" tab. view image