How to create, print barcodes in SAP Crystal Reports for .NET applications?

How to print barcodes with specified width & height in Crystal Reports using C#?

Top

1. Customize barcode resolution and size settings

linear.UOM = UnitOfMeasure.INCH;
linear.Resolution = 600;
linear.BarcodeWidth = 5;
linear.BarcodeHeight = 2;

2. Update the barcode object in the report properties

Open file CrystalReport1.rpt in Visual Studio

Select the barcode object in the report, and change the following properties.

• Set XScaling to 5
• Set YScaling to 2

Right click barcode object, and choose Format Object. Go to tab Picture.

Make sure the size settings are correct.

3. View, measure the barcode in Crystal Reports

Run the Windows Forms project, and view the barcodes printed in the report.



View the rendered barcodes in PDF exported from Crystal Reports.

How to Generate Barcode Images in .NET Crystal Reports

Top

1. In our demo dataset "BarcodeDemoData.mdb", there is a table "Customer", with three columns inside: "ID", "CustomerId", "CustomerName".
2. There is a CustomerDataSet.xsd file for "BarcodeDemoData.mdb", which defines all above three columns in Customer table, also define one extra column named "Barcode", with data type "xs:base64Binary".
3. In the following example, we will show you how to display all three column data and also with the extra barcode column which displays Code 128 barcode with "CustomerId" value encoded.

1. Create a new .NET project with "Crystal Reports Application" as template. Name the project as "CrystalReportsBarcode".
   
   


2. Create a new report "Using the Report Wizard", and choose "Standard", and click "OK" button.
3. In "Data" form, expand "Create New Connection", and expand "ADO.NET".
   
   


4. In "Connection" form, select the "CustomerDataSet.xsd" in your downloaded sample dataset package. Then click "Finish" button.
   
   


5. In "Data" form, and add table "Customer". Then click "Next".
   
   


6. In "Fields" form, add all three columns in the table "Customer". Click "Finish".
   
   


7. In CrystalReport1.rpt, add field "Barcode" to the report Section 3 (Details).
   
   


8. In your .NET project solution explorer, add "OnBarcode.Barcode.WinForms.dll" to your project reference.
9. Open your Form1.cs in Design view, double click the form, enter Form1.cs.
   
   
10. Copy the following C# code into the method Form1_Load.

   private void Form1_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[])));
   Linear barcode = new Linear();
   barcode.Type = BarcodeType.CODE128;
   foreach (DataRow dr in ds.Tables[0].Rows)
   {
   barcode.Data = (int)dr["CustomerId"] + "";
   byte[] imageData = barcode.drawBarcodeAsBytes();
   dr["Barcode"] = imageData;
   }
   CrystalReport1 rpt = new CrystalReport1();
   rpt.SetDataSource(ds);
   this.crystalReportViewer1.ReportSource = rpt;
   aConnection.Close();
   }

11. Run the report.