BarCodeWiz Logo

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

Before You Begin

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 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 3. Edit Image Properties

  1. Right - click on inserted image object and select "Image Properties..."

  1. Select Database as the image source
  2. Select image/png as the MIME type
  3. Click on the Fx button to open the Expression window

  • 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

The Report is ready!

  • Preview the generated report