How to Generate EAN-13 in SSRS
EAN 13, one member of the EAN / UPC barcode family, is an extension of barcode UPC-A. It is a linear barcode encodes 13 digits (include one check digit) which was based on the standards of GS1. It is widely used in retailing system that crosses the point-of-sale.
Barcode Generator for SSRS is a mature .NET CRI component which supports all Microsoft Report Definition Language scenarios such as SQL Server Reporting Services as well as Visual Studio 2005, 2008 and 2010. Product provide by BusinessRefinery is completely written in C#.NET 2005.
EAN 13 .NET Control for SSRS is a custom report item control which designed for displaying high quality barcode images on SSRS projects. Layout of barcode images can be altered dependent on your project needs by using this fully-integrated visual barcode generator.
This .NET barcode control provides detailed tutorial on how to create EAN 13 in SSRS by using .NET generation SDK and complex barcode know-how is not required. Guideline includes EAN 13 valid character set, barcode size setting, barcode standard and IDE & OS requirement in SQL Server Reporting Services.
EAN 13 Barcode Generation in Reporting Services (SSRS)
|
Encodable Characters |
Valid character set includes:
- 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
|
Development Environment |
This custom report item control is compliant with .NET Framework 2.0, 3.0, 3.5 and above version. |
|
Supplemental Digit Support |
EAN 13 five-digit add-on and two-digit add-on may be utilized just to the right of the main barcode symbol to encode detailed information. |
|
Property Setting |
Users have full control over every aspect of properties relating to X, Y dimension, barcode width & height, quiet margin etc. |
|
Exporting Option |
Customized reports with barcode images could be exported to other file formats such as Word, Excel, PowerPoint and PDF documents. |
|
Text Support |
Customization of barcode fonts, character size, text margin and color are acceptable provided the interpretation is clearly legible. |
Requirement of EAN 13 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", and then click "Finish" to complete the creation process.
Generate EAN 13 Barcode Images in SQL Server Reporting Services
- Navigate to "Avapose.linearbarcode.winforms.dll" and add it as item on toolbox, then barcode item "LinearWinControl" will be displayed on toolbox.
- "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 EAN 13 image.
