BarCodeWiz Logo

UPC EAN Barcodes in SQL Server Reporting Services (SSRS) - as Text

How to create barcodes in SSRS

  • BarCodeWiz UPC EAN Fonts can be used to create barcodes in SSRS.
  • Follow the steps below, or watch the video. 

Before You Begin


Step 1. Create a new report.

  • Click on File > New > Blank Report

Step 2. Connect your Data Source.

  • In this example, we are using a simple 3 column items data set.

Step 3. 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.

  • Right-Click > Expression... .

  • Edit the expression as shown
  • We are using the function UPCA()

  • Let's preview the report. It should look like this.:

Set Font Properties

  • Set Font Name to: BCW_UPCEAN_2
  • Set Font Size to: 22

Step 4. Finalize and generate report

  • Under the Home tab, in the Views section click Run to generate the report.

  • The final result

UPC EAN Fonts Functions in SSRS


UPCA(barcode as String)

  • Encodes the barcode in UPC-A format.
  • The function parameters are:

    barcode: String value with the barcode data to encode. Must be 11 or 12 digits. Enter 11 digits to have the check digit added automatically. Also accepts 13, 14, 15, or 17 digits for +2 and +5 Add-on

UPCE(barcode as String)

  • Encodes the barcode in UPC-E format.
  • The function parameters are:

    barcode: String value with the barcode data to encode. Must be 7 or 8 digits. Enter 7 digits to have the check digit added automatically. Also accepts 9,10, 12, or 13 digits for +2 and +5 Add-on

EAN13(barcode as String)

  • Encodes the barcode in EAN-13 format.
  • The function parameters are:

    barcode: String value with the barcode data to encode. Must be 12 or 13 digits. Enter 12 digits to have the check digit added automatically. Also accepts 14, 15, 17, or 18 digits for +2 and +5 Add-on

EAN8(barcode as String)

  • Encodes the barcode in EAN-8 format.
  • The function parameters are:

    barcode: String value with the barcode data to encode. Must be 7 or 8 digits. Enter 7 digits to have the check digit added automatically.

ToImageBytes(strText As String, fontName As String, Optional fontSize As Integer = 12, Optional dpi As Float = 96f, Optional imageType As String = "png") As Byte[]

  • Converts text into image as byte array. May be used to return barcodes as images.
  • The function parameters are:

    strText: Text to be converted to image
    fontName: Font to use for encoded text
    fontSize: Font point size of the text
    dpi: Dots per inch of resulting image. Default value is 96.0 (screen resolution)
    imageType: Image format to return. Possible values are: png, gif, bmp, jpg