QR Code 2D Barcodes in SQL Server Repoting Services SSRS - as Images
How to create barcodes as images in SSRS
- BarCodeWiz QR Code Fonts may be used to create barcodes as images in SSRS
- Follow the steps below, or watch the video, to add barcodes to your own report
![](https://media.barcodewiz.com/images/c8edc1dd-99f3-45d3-903a-0f4ad47af4b5-qr_ssrs_as_image_000.png)
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...
![](https://media.barcodewiz.com/images/15fd5784-02a6-4b30-8e84-157909459ff7-ssrsdll2.png)
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.
![](https://media.barcodewiz.com/images/29a917cf-2fcf-4332-ba60-e881fecef6ef-QR-SSRS-002.png)
Step 2. 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
![](https://media.barcodewiz.com/images/894db2e5-2923-4415-9701-dfe4d56c411a-qr_ssrs_as_image_001.png)
Step 3. Edit Image Properties
- Right - click on inserted image object and select "Image Properties..."
![](https://media.barcodewiz.com/images/06e448d8-9720-423a-97e9-fe12a20cc20b-qr_ssrs_as_image_003.png)
- Select Database as the image source
- Select image/png as the MIME type
- Click on the Fx button to open the Expression window
![](https://media.barcodewiz.com/images/7a3b13cf-1bd9-4534-af9c-870d7a3505b9-qr_ssrs_as_image_002_01.png)
- Set the value for the expression:
=Code.MyQrCode.ToImageBytes( Code.MyQrCode.Encode(Fields!item_sku.Value , quietZoneWidth:=5), "BCW_QR", 8, 300.0, "png" ) - Replace item_sku with the name of the field from your dataset
![](https://media.barcodewiz.com/images/543263b8-9f7d-42af-8ac4-2cf9936f8e49-qr_ssrs_as_image_004.png)
The Report is ready!
- Preview the generated report
![](https://media.barcodewiz.com/images/f6263d3c-c764-40d5-adac-cd5ae0d3c7b4-qr_ssrs_as_image_005.png)