How to Generate UPC-A in SSRS
UPC-A is a 12 digits long linear barcode symbology that is widely used in retail field for tracking trade item in North America, UK, Australia, and New Zealand. A typical UPC-A barcode contains four parts: number system, manufacturer code, product code and checksum digit. Among them, checksum character is automatically computed by Barcode Generator for SSRS.
Barcode Generator for Reporting Service is a robust and reliable .NET CRI component that gives you perfect solution of generating barcodes in Reporting Service in SQL Server 2005 and 2008 projects with high quality.
This .NET assembly entirely runs in VB.NET and C# in .NET Framework 2.0, 3.0 and advanced version. The managed code is 100% created in C#. Source code is available with purchase of the developer license.
With Reporting Service UPC-A Generator, developers are free to customize barcode properties to adjust the appearance of barcode images according to their needs. This page gives you a detail guide of how to generate UPC-A in Reporting Service.
UPC-A Generator for SSRS Features
|
Encodable Characters |
Support to encode:
- Digital characters: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
|
|
Easy installation |
Bound to SQL Server database fields as integrated control |
|
Programming Languages |
Completely run in VB.NET, C#, Managed C++ and Borland Delphi for .NET |
|
Supplementary Barcode |
Support supplementary barcodes UPC-A+2 and UPC-A+5 generation in Reporting Service |
|
Selectable Orientation |
The generated UPC-A can be displayed in four different angles (0, 90, 180, 270) |
|
Flexible Size Options |
Flexible to adjust X dimension, Y dimension, image width, image height, etc to make required barcodes. |
UPC-A Generator for SSRS Requirements
Windows OS
-Microsoft Windows 7
- Windows Server 2008
- Windows Vista
- Windows Server 2003
- Windows XP |
Development Environments
- .NET 2.0/3.0/4.0
- C#, VB.NET, Managed C++, Borland Delphi for.NET
- Visual Studio 2005/2008/2010
- SQL Server 2005 / 2008 Reporting Services
- Visual Studio 2005 / 2008 ReportViewer Local Reports (RDLC) (runtime support) |
Install UPC-A Generator for SSRS
- Download Barcode Generator for SSRS Free Trial and unzip;
- Copy CRI to the project folder;
- Add "BusinessRefinery.Barcode.win.dll" to Visual Studio Toolbox;
How to Integrate UPC-A into SSRS
- Download Barcode Generator for SSRS Free Trial and unzip;
- Copy "BusinessRefinery.Barcode.RS2005CRI.dll" and "BusinessRefinery.Barcode.RS2005.dll" to the folder: "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\". For SQL Server 2008, copy "BusinessRefinery.Barcode.RS2008CRI.dll" and "BusinessRefinery.Barcode.RS2008.dll" to the folder: "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\";
- Copy "BusinessRefinery.Barcode.RS2005CRI.dll" or "BusinessRefinery.Barcode.RS2008CRI.dll" to the folder: "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\";
- Start Visual Studio and create a new report project by choosing "Report Server Project Wizard" from Visual Studio installed templates;
- Add a "Data Source" to the project. We are using "AdventureWorks" as our data source;
- Add query string to retrieve data from the data source;
- Choose a "Tabular" report style;
- Use the default settings in "Design the Table" Dialog, and click "Next";
- Choose the default setting for "Table Style";
- Use the default location to deploy the report;
- Set the name of the report and click "Finish" button;
- Add Business Refinery Reporting Service Barcode CRI to your Report Item Toolbox;
- Add a new column for barcode images. Right-click the table and choose "Insert Column to the Right";
- Set the column header as "Barcode" and then, drag "LinearBarcodeControl" directly to the Column "Barcode";
- Select linear barcode. Go to property window, and change barcode type to UPC-A;
- Change other parameters if needed and click "Preview" tab to view the generated barcodes.
