How to Generate Code 39 in SSRS
Code 39, also known as USS Code 39, USS 39, Alpha39, is the first alphanumeric symbology which was designed in 1974. Code 39 is self-checking, discrete, linear barcode which utilizes start and stop characters, intercharacter gaps and allows bi-directional scanning.
Barcode Generator for SSRS is designed to automate barcode generation in SQL Reporting Services. This mature barcode control support Code 39 & Code 39 Extended as well as other 20+ linear (EAN 13, UPC-A, Codabar etc.) and 2D barcodes (QR Code, Data Matrix and PDF 417) creation in SSRS projects.
Code 39 .NET Control for SSRS is an easy-to-configure barcode generator which performs well on computers running Microsoft SQL Server 2000, 2005 and 2008 Reporting Services. Code 39 barcode images could be inserted into SSRS in a reliable manner by using .NET control with CRI.
This page provides complete information on how to create Code 39 in SSRS by using .NET generation SDK. It specifies Code 39 symbology valid character set, barcode property customization, barcode standard and IDE & OS requirement in SQL Server Reporting Services.
Code 39 Barcode Generation in Reporting Services (SSRS)
|
Encodable Characters |
Able to encode:
- Numeric data: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
- Uppercase letters: A - Z
- Seven special characters: -, $, :, /, ., +
|
|
IDE Support |
Fully-integrated barcode generator for Visual Studio 2005, 2008 and 2010 to automate barcode handling in SSRS. |
|
High Quality |
Create high quality barcode images in low and high resolution and print them to all printers including Zebra Thermal Printers by writing .NET code in VB.NET or C#. |
|
Barcode Standard |
Code 39 created by this .NET barcode generator supports the features defined in international standard ISO / IEC 16388. |
|
Text Option |
Customization of barcode fonts, character size, text margin and color are acceptable provided the interpretation is clearly legible. |
|
Start & Stop Characters |
The Code 39 start and stop character is usually depicted in human-readable form by a * and could be positioned at the normal left & right end of the data symbol character or disabled. |
Requirement of Code 39 Barcode Generator for SSRS
Windows Operating Systems
- Microsoft Windows 7
- Windows Server 2008
- Windows Vista
- Windows Server 2003
- Windows XP |
Development Environments
-.NET Framework 2.0, 3.0, 3.5, 4.0
- C#, VB.NET, Managed C++, Borland Delphi for.NET
- Visual Studio 2005/2008/2010
-Microsoft SQL Server 2005, 2008 or 2010 |
Create New Reporting Services Project in Visual Studio
- Download and unzip the Barcode Generator for SSRS Free Trial
- Start Visual Studio and create new "Business Intelligence Projects", and then select "Report Server Project Wizard" template. In the popped up "Connection Properties" form, select "AdventureWorks" as data source and lick "OK".
- Copy "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer" to the Query string input box of "Report Wizard" window, and then click "Next".
- Select "Tabular" as report type and click "Next".
- In next 3 dialogs "Design the Table", "Choose the Table Style", "Choose the Deployment Location", choose default setting of them and click "Next".
- Name the report "Barcode in Reporting Service 2005", then click "Finish" to complete the creation process.
Generate Code 39 Barcode Images in SQL Server Reporting Services
- barcode item "LinearWinControl" will be displayed on toolbox.
- Add column named "Barcode" to show the barcode images to the report, then drag and drop the "LinearWinControl" to the "Barcode" column.
- Switch to "Properties" window and change property "BarcodeData" to "=Fields!AccountNumber.Value".
- Click "Preview" tab to view the report with Code 39 image.
