BarCodeWiz Logo

Code 39 Barcodes using SQL Server Reporting Services SSRS -As Text

How to create barcodes in SSRS using BarCodeWiz Code 39 Fonts

  • This tutorial shows how you can add barcodes to SQL Server Reporting Services.
  • Barcodes are encoded using text inserted into a table (See also: Create Code 39 Barcodes as Images).

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.Code39
  • 3) Click Add to add a class instance
  • 4) Type BarCodeWizFonts.Code39.Code39Fonts for class name and MyCode39 for instance name

Step 2. Insert a data column

  • Drag and drop a one of your columns from your DataSet into the report.
  • In this example, the data field is placed inside a Table

Step 3. Edit Properties

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

Step 4. Set Font Properties

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

The Result

  • The report is now ready.

Additional Code 39 Functions available in MS SSRS

Code39(barcode as a String)

  • Code39Check() encodes text into Code 39.
  • Accepts the following characters: 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%
  • Example 1: =Code.MyCode39.Code39( "4567ABCD" ) 
    Example 2: =Code.MyCode39.Code39( Fields!item_sku.Value ) -  Encodes data from column in item_sku table. 

Code39Check(barcode as a String)

  • Code39Check() encodes text into Code 39. Adds a MOD 43 check digit to the end of the barcode.
  • Accepts the following characters: 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-. $/+%
  • Example 1: =Code.MyCode39.Code39Check( "4567ABCD" ) 
    Example 2: =Code.MyCode39.Code39Check( Fields!item_sku.Value ) -  Encodes data from column in item_sku table.