How to insert GS1-128 barcodes in Microsoft SQL Server Reporting Services (SSRS) reports
Avapose.Barcode for SQL Reporting Services
  • Create dynamic UCC/EAN-128 in SQL Reporting Services reports
  • Easy to use GS1-128 barcode generating DLL assembly for SSRS
  • Compatible with Reporting Services SQL Server 2005/2008/2008 R2/2012
GS1-128 Barcode Generation in SSRS reports
  • Generate dynamic GS1-128 in SQL Reporting Services (SSRS) with a Custom Report Item (CRI)
  • GS1-128/EAN-128 barcode image generation in SQL Server 2005 and 2008
  • Provide managed code written in C# with strong-named, digitally signed and time-stamped DLL
  • Completely develop in Visual Studio 2005 / 2008, SQL Server 2005 / 2008 Reporting Services, and Visual Studio 2005 / 2008 ReportViewer Local Reports (RDLC)
  • Data binding API is provided within the .NET GS1-128 Control to bind to fields in SQL Server
  • Easy to generate Application Identifier for GS1-128 in Reporting Service
  • Generated GS1-128 can be displayed as high-quality Gif, Tiff, Bmp, Png or Jpeg image
  • GS1-128 barcode image default value pre-configured for easy generation
GS1-128 Generator for SSRS (CRI) is the most flexible and powerful .NET assembly that adds GS1-128 barcoding features into Reporting Service. The created GS1-128 images can be saved as image in GIF, TIFF, BMP, PNG or JPEG format. Users may also output GS1-128 in Bitmap, Stream or Graphics objects.
.NET GS1-128 Generator Control for Reporting Service Development:
  • Visual Studio 2005 / 2008 & SQL Server 2005 / 2008 Reporting Services - Report Server Project (design-time and runtime support)
  • Visual Studio 2005 / 2008 ReportViewer Local Reports (RDLC) (runtime support)
Barcode Generation for Reporting Service - GS1-128 Information
The GS1-128(formerly UCC128/EAN-128) is a subset of Code 128 symbology with the adding of FNC1 in Code 128 symbol in the first symbol character position. GS1-128 has a list of predefined AI which defines the meaning of data such as best before dates, batch numbers, quantities, etc. The AI is often enclosed in parentheses when encoding GS1-128 data. Because of the standardization of GS1-128, it is widely used in non retail field in the world.
.NET GS1-128/EAN-128 Generator for SQL Server Reporting Service encodes:
  • Standard ASCII values from 0 to 127
  • Extended ASCII values from 128 to 225
Barcode Generation for Reporting Service for .NET - GS1-128 Generation

Requirements:

To generate GS1-128 in Reporting Services, you need to install:
  • Windows 2000, Windows XP, Windows Vista, Windows 7, etc
  • .NET Framework 2.0, 3.0, 3.5, 4.0, or greater
  • Microsoft Visual Studio 2005/2008
  • SQL Server 2005/2008
  • Avapose.Barcode for Reporting Service

Generate GS1-128 Barcode in SQL Server Reporting Service

  1. Deploy barcode controls:
    • If you are SQL 2005 users, please open directory "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\". Copy "Avapose.Barcode.RS2005CRI.dll" and "Avapose.Barcode.RS2005.dll" to the folder. For SQL 2008 users, open directory "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\". Copy "Avapose.Barcode.RS2008CRI.dll" and "Avapose.Barcode.RS2008.dll" to the folder;
    • Open directory "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\". Copy "Avapose.Barcode.RS2005CRI.dll" or "OnBarcode.Barcode.RS2008CRI.dll" to the folder; (MSSQL.3 is a machine specific. It may be MSSQL.1, MSSQL.2, or MSSQL.4.)
  2. Create a new report in Reporting Service:
    • Create a new report in Visual Studio;
    • Select data source. We are using "AdventureWorks" as our data source. Click "Next";
    • Create query string. Copy "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer" to the Query string input box;
    • Use the default settings in the next steps until name the report. Name the report as "Barcode in Reporting Service" and click "Finish";
  3. Add Avapose Reporting Service Barcode CRI to your Report Item Toolbox:
    • Right click "Report Items" and select "Choose Item...";
    • Go to ".NET Framework Components", and click "Browse..." button;
    • Select "Avapose.Barcode.RS2005.dll"/"Avapose.Barcode.RS2008.dll";
    • Press "OK", you will see two components in your Report Item Toolbox: "LinearBarcodeControl" and "MatrixBarcodeControl";
  4. Add a new column to display GS1-128 in your report:
    • In the report, please 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".
    • Go to property window, change barcode type to GS1-128, and change other parameters if necessary.
  5. Click tab "Preview" to view the created report.
Related GS1-128 Barcode Integration & Generation Information
The following GS1-128 (EAN/UCC128) barcode integration and creation information links relate to this product that may be of interest to you:
Testimonial for SSRS Barcode Generator
We bought your Barcode Generator for Reporting Service a few weeks ago, and it works pretty well
Carios Louis, Eureka Software Ltd,UK