Micro QR Code Barcodes made in SQL Server Reporting Services
How to make Micro QR Barcodes in SSRS using BarCodeWiz QR Code Fonts
- This tutorial shows how you can add QR Code 2D barcodes to SQL Server Reporting Services.
Before You Begin!
- Ensure BarCodeWizFonts.QrCode.dll, as well as the font files, are installed on the server.
- See BarCodeWiz Fonts in SSRS - Installation
Step 1. Configure Report Properties
- Open Properties Window - right-click in the report background area and click Report Properties...
Add Reference:
- In the Report Properties window, select the References section.
- 1) Click Add to add the assembly.
- 2) Type: BarCodeWizFonts.QrCode.
- 3) Click Add to add a class instance.
- 4) Type BarCodeWizFonts.QrCode.QrCodeFonts for class name and MyQrCode for instance name.
Step 2. Insert a Text Box
- Insert a text box into the report by dragging one of the columns from your DataSet.
- In this example, the text box is placed inside a Table
Step 3. Edit Text Box Properties
- Right-Click > Expression...
- Edit the expression as shown
- In our example, we encoded the Micro QR Code in size M3
NOTE: SymbolSize 41 through 44 represent Micro QR Sizes M1 through M4.
- Let's preview the report. It should look like this:
Step 4. Set Font Properties
- Set Font Name to: BCW_QR
NOTE: For smaller barcodes, you can set the point size as low as 2pt
The Report is ready!
Create Micro QR Code as Images
- BarCodeWiz QR Code Fonts may be used to create Micro QR Code Barcodes as images in SSRS
- This approach simplifies the process of preparing reports in large organizations.
- The initial steps (DLL and Fonts Installation; setting Report properties) are the same as if you were preparing barcodes based on text.
Step 1. Insert image
- Insert an image into the report by dragging one of the columns from your DataSet
- In this example, the image is placed inside a Table
Step 2. Edit Image Properties
- Right - click on the inserted image object and select "Image Properties..."
- Select Database as the image source
- Select image/png as the MIME type
- Click on the Fx button to open the Expression window
- Set the value for the expression:
=Code.MyQrCode.ToImageBytes( Code.MyQrCode.Encode( Fields!item_name.Value, symbolSize:=43, quietZoneWidth:=5 ), "BCW_QR", 8, 96.0 ) - Replace item_name with the name of the field from your dataset
- In our example, we encoded the Micro QR Code in size M3
NOTE: SymbolSize 41 through 44 represent Micro QR Sizes M1 through M4.
Preview the generated report
