How to Generate EAN-128/GS1-128 in Crystal Reports
GS1-128, formerly known as EAN-128 or UCC-128, was developed to provide a worldwide format and standard for exchanging common data between companies. Today, GS1-128 is used globally especially in shipping industry for identifying product information.
Barcode Generator for Crystal Report is a .NET component developed to generate 20+ linear & matrix barcode in Crystal Report. The generator is a control library with barcode generation capabilities. The control could be installed and used easily in Crystal Reports for .NET.
GS1-128 Crystal Report Generator is specially designed for the need of printing GS1-128 in Crystal Report. The integrated GS1-128 draws high quality graphics object in your reports. The generated barcode is highly customizable. Here is a detailed use guide for creating GS1-128 barcodes in Crystal Reports.
GS1-128 Generator for Crystal Report Features
Valid Data |
Valid character set includes:
- 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 - Uppercase letters (A - Z) - Lowercase letters (a - z) - - (Dash), $ (Dollar), % (Percentage), (Space), . (Point), / (Slash), + (Plus) |
Checksum Calculation |
Automatically calculate possible checksum digit for your specified data string. |
Size Adjustments |
Include flexible size customization solutions, including the size setting of bar, space, margins, and text. |
Human-Readable Text |
Display adjustable human-readable text below the GS1-128 barcode symbol. |
Application Identifiers |
Easily encode GS1 Application Identifiers with GS1-128 barcode symbol. |
Royalty-free Distribution |
Offer royalty-free license with purchase license. |
GS1-128 Generator for Crystal Report Requirements
Windows OS
- Windows 7 - Windows Vista - Windows XP |
Development Environments
- .NET 2.0, 3.0 or later version - C#, VB.NET, Managed C++, Borland Delphi for .NET - Microsoft Visual Studio 2005/2008/2010 |
How to Create a Crystal Report for .NET
- Download Barcode Generator for Crystal Report and unzip;
- Open Visual Studio and create a web project using "ASP.NET Crystal Report Web Site";
- Select the Crystal Report Template, then name and locate the report;
- When the Crystal Report Gallery dialog box appears, accept the defaults of "Use Report Expert" and "Standard Report", and click "OK";
Setup in Crystal Report for .NET
- Select "ADO.NET" in "Create New Connection" when Crystal Reports wizard dialogue pops up;
- Browse and find "CustomerDataSet.xsd" in your downloaded sample dataset package (or any other dataset of your own), then click "Finish";
- Click on the Tables node to expand;
- Drag and drop the table name to the window titled Tables In Report, and click "Next";
- To display fields on the report, select them at the Field tab, and click "Finish";
- Modify the form so that it can preview and print the report;
How to Generate GS1-128 in Crystal Report for .NET
- Drag and drop the field named "Barcode" to the report in Crystal Report1.rpt;
- Open Form1.cs in Design view, and add Barcode .linearbarcode.aspnet.dll to the project reference;
- Double click Form1 to enter Form1.cs, and copy the sample code into the method Form_Load;
- Using the namespace "BizCode.linearbarcode" if your report is created in C#.NET;
GS1-128 Generation Sample Code
Run the web project;
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection aConnection = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Demo/BarcodeDemoData.
mdb");
aConnection.Open();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter
("select * from Customer", aConnection);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
//add a new column named "Barcode" to the DataSet, the new column data
type is byte[]
ds.Tables[0].Columns.Add(new DataColumn("Barcode", typeof(byte[])));
WebLinearBarcode barcode = new WebLinearBarcode ();
barcode. Symbology = Symbology.EAN128;
foreach (DataRow dr in ds.Tables[0].Rows)
{
barcode.Data = (int)dr["CustomerId"] + "";
byte[] imageData = barcode.drawBarcodeAsBytes();
dr["Barcode"] = imageData;
}
CrystalReportSource1.ReportDocument.Load(Server.MapPath
("CrystalReport1.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);
CrystalReportSource1.DataBind();
aConnection.Close();
}
Protected Sub CrystalReportViewer1_Init(ByVal sender As Object,
ByVal e As System.EventArgs) Handles CrystalReportViewer1.Init
Dim aConnection As New OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:/Demo/BarcodeDemoData.mdb")
aConnection.Open()
Dim dataAdapter As New OleDbDataAdapter("select * from Customer",
aConnection)
Dim ds As New DataSet()
dataAdapter.Fill(ds)
'add a new column named "Barcode" to the DataSet, the new column
data type is byte[]
ds.Tables(0).Columns.Add(New DataColumn("Barcode", GetType(Byte())))
Dim barcode As New WebLinearBarcode ()
barcode. Symbology = Symbology.EAN128
For Each dr As DataRow In ds.Tables(0).Rows
barcode.Data = CInt(dr("CustomerId")) & ""
Dim imageData As Byte() = barcode.drawBarcodeAsBytes()
dr("Barcode") = imageData
Next
CrystalReportSource1.ReportDocument.Load(Server.MapPath
("CrystalReport1.rpt"))
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables(0))
CrystalReportSource1.DataBind()
aConnection.Close()
End Sub