Java Barcode Generator, .NET Barcode Generator for C#, ASP.NET, VB.NET
HOME BARCODE FOR .NET CRYSTAL PURCHASE

How to Create Crystal Reports Featuring Barcode Images Using Typed DataSet in .NET Windows Forms



Quick Navigate





1. Prerequisites
  • BarcodeLib.Barcode.CrystalReports.dll
  • Microsoft .NET Framework 2.0 (or later)
  • Crystal Report for Visual Studio .NET 2010

2. Create Barcode Image in Crystal Reports for .NET Windows Forms
  • Create a new Windows Application Project.
    1. Create a new project using "Crystal Reports Application" as template, named "BarcodeforCrystalReports".


  • Add a Crystal Report item to the project.
    1. Add a new item (Crystal Report), named "CustomerReport.rpt" to the project. view image
    2. Select Expert as "Mail Label". Click "OK" button. view image
    3. In "Mailing Labels Report Creation Wizard", click "Create New Connection", and expand "ADO.NET". view image
    4. In "ADO.NET" form, select "CustomerDataSet.xsd" file in your downloaded package, and click "Finish" button. view image
    5. In "Mailing Labels Report Creation Wizard", add table "Customer" under "ADO.NET", to selected table. And click "Next" button. view image
    6. Add all three fields "ID", "CustomerId", "CustomerName", to "Fields to Display:". Click "Next". view image
    7. Select default label "Return Address (Avery 5267)", and click "Finish" button.
    8. Now you can view the report template, and find that field "Barcode" not in the report template. view image
    9. Re-arrange the report template. view image
    10. Drag field "Barcode" to the report template. And Right click "Barcode" object, select "Format Object" menu. view image
    11. In "Format Editor" form, check "Can Grow" property. view image


  • Add Crystal Report Viewer to the window form.
    1. Resize "Form1", and add "CrystalReportViewer" to the form, with the default setting unchanged. view image
    2. Add a reference to BarcodeLib.Barcode.CrystalReports.dll.
    3. Add the following code to the Form1.cs file.
      using System.Data.OleDb;
      using System.Drawing.Imaging;
      using BarcodeLib.Barcode.CrystalReports;
      using BarcodeLib.Barcode;
      
    4. Add the following code to the Form1.cs file.
         private void Form1_Load(object sender, EventArgs e)
         {
         //create the database connection. Please change to correct data file (BarcodeDemoData.mdb) path.
         OleDbConnection aConnection = new OleDbConnection(
            "Provider=Microsoft.Jet.OLEDB.4.0;
            Data Source=C:/BarcodeLib_NETBarcode_Trial/ReportingData/BarcodeDemoData.mdb");aConnection.Open();
    
         OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM Customer", aConnection);
         DataSet ds = new DataSet();
         dataAdapter.Fill(ds);
    
         //Add the Barcode column to the DataSet
         ds.Tables[0].Columns.Add(new DataColumn("Barcode", typeof(byte[])));
    
         //Create an instance of Linear Barcode
         //Use DataMatrixCrystal for Data Matrix
         //Use PDF417Crystal for PDF417
         //Use QRCodeCrystal for QR Code
         LinearCrystal barcode = new LinearCrystal();
         //Barcode settings
         barcode.Type = BarcodeType.CODE128;
         barcode.BarHeight = 50; //50 pixel
         barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Png;
    
         foreach (DataRow dr in ds.Tables[0].Rows)
         {
            barcode.Data = (int)dr["CustomerId"] + "";
            byte[] imageData = barcode.drawBarcodeAsBytes();
            dr["Barcode"] = imageData;
         }
    
         CustomerReport rpt = new CustomerReport();
         rpt.SetDataSource(ds);
    
         this.crystalReportViewer1.ReportSource = rpt;
    
         //close the connection Its important.
         aConnection.Close();
    
         }


  • Run the project.


 

3. Property Settings for Each Barcode Types











   Copyright BarcodeLib.com. All rights reserved.