Code 128 Barcodes with SQL Server Reporting Services SSRS -As Text

How to create barcodes in SSRS using BarCodeWizFonts.Code128.dll

  • This tutorial shows how you can add barcodes to SQL Server Reporting Services.
  • Barcodes are encoded using text inside a Text Box. (see also: Create barcodes as Images)

Before You Begin

Step 1. 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 2. Edit Text Box Properties

  • Right-Click > Expression...
  • Edit the expression as shown
  • We are using the function Code128B()
  • Let's preview the report. It should look like this:

Step 3. Set Font Properties

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

The Result

  • The report is now ready.

 

 

 

 

Code 128 Fonts Functions in SSRS

Code128Auto(barcode as String)

  • Code128Auto() Encodes data in the most efficient way possible, using a combination of subsets if necessary. Supports all 128 ASCII characters.
  • This function should be used with one of the following fonts:
    BCW_Code128_1 through BCW_Code128_6 (does not show human readable text)
  • This function requires the use of a barcode font without human readable text. However, the text can easily be displayed in a separate formula field with a font such as Arial.
  • To encode a control character, enter it in the format: ^000, where 000 is its digital ASCII value. For example, ABC^009 encodes ABC followed by TAB. To encode FNC1, enter: ^F1
  • Example 1: =Code.MyCode128.Code128Auto("abc123")
    Example 2: =Code.MyCode128.Code128Auto("abc123^009") - Encodes abc123 followed by TAB
    Example 3: =Code.MyCode128.Code128Auto(Fields!ProductNumber!Value) - Encodes data from your ProductNumber column in your DataSet

Code128A(barcode as String)

  • Code128A() Encodes data using Code 128 Subset A only. It supports numbers, upper case letters, control characters (such as tab or new-line), space, and the following: !"#$%&'()*+,-./:;<=>?@[\]^_
    To encode a special character (like TAB), encode it in the format ^000, where 000 is the decimal ASCII number.
  • Use this function with one of the following fonts:
    BCW_Code128A_1 through BCW_Code128A_6 (shows human-readable text under barcode)
    BCW_Code128_1 through BCW_Code128_6 (does not show human readable text)
  • Example 1: =Code.MyCode128.Code128A("ABC123")
    Example 2: =Code.MyCode128.Code128A("ABC123^009") - (Encodes ABC123 followed by TAB)

Code128B(barcode as String)

  • Code128B() Encodes data using Code 128 Subset B only. It supports numbers, upper and lower-case letters, space, and the following characters: !"#$%&'()*+,-./:;<=>?@[\]^_`{|}~
    To encode special characters like TAB or CARRIAGE RETURN, use format ^000 where 000 is the decimal ASCII number (For example, ^009 for TAB). Special characters are supported by temporarily shifting to Subset A. This process is automatic.
  • Use this function with one of the following fonts:
    BCW_Code128B_1 through BCW_Code128B_6 (shows human-readable text under barcode)
    BCW_Code128_1 through BCW_Code128_6 (does not show human readable text)
  • Example 1: =Code.MyCode128.Code128B("abc123")
    Example 2: =Code.MyCode128.Code128B("abc123^009") - Encodes abc123 followed by TAB
    Example 3: =Code.MyCode128.Code128B(Fields!ProductNumber!Value) - Encodes data from your ProductNumber column in your DataSet

Code128C(barcode as String)

  • Code128C() Encodes data using Code 128 Subset C. It supports numbers only and must contain an even number of digits.
  • The digits are encoded in pairs of two, resulting in a barcode about half as wide as subset A or B.
  • Use this function with one of the following fonts:
    BCW_Code128C_1 through BCW_Code128C_6 (shows human-readable text under barcode)
    BCW_Code128_1 through BCW_Code128_6 (does not show human readable text)
  • Example 1: =Code.MyCode128.Code128C("00123456")
    Example 2: =Code.MyCode128.Code128C(Fields!ProductNumber!Value) - Encodes data from your ProductNumber column in your DataSet