How to Print Barcodes in Crystal Reports with VB.NET

What Are the Methods for Printing Barcodes in Crystal Reports?

Two primary approaches exist for adding barcodes to Crystal Reports: font-based methods and SDK solutions.

Font-based methods require installing special barcode fonts (True Type fonts) in your fonts folder and using formulas or a User Function Library (UFL) to encode data. While this approach works, it often involves complex encoding formulas, limited barcode format support (such as Code 39 or data matrix), and potential font rendering issues across different printers and systems, as discussed in Microsoft's documentation on font rendering.

SDK-based solutions provide a more dependable alternative. These libraries generate barcode images programmatically, offering better reliability, extensive format support, and easier implementation. IronBarcode exemplifies this modern approach, allowing developers to generate barcodes as images that integrate with Crystal Reports through standard database fields or DataTable objects. This method ensures consistent rendering across all platforms and eliminates font dependency issues when printing a barcode in a Crystal Report using VB.NET.

How Do You Install IronBarcode for VB.NET?

Setting up IronBarcode in your VB.NET project requires minimal configuration. First, install the library through NuGet Package Manager by running:

Install-Package BarCode

Install-Package BarCode

Alternatively, use the Package Manager UI in Visual Studio to search for and install "BarCode". Once installed, import the namespace in your VB.NET code:

Imports IronBarCode

Ensure your project targets .NET Framework 4.6.2 or higher, or any version of .NET Core, .NET 5, or .NET 6+. IronBarcode works with all Crystal Reports versions that support image fields, making it broadly compatible with existing projects. For detailed setup instructions, refer to the IronBarcode getting started guide.

Download IronBarcode today to start creating professional barcodes in your Crystal Reports.

How Do You Generate Barcodes and Store Them in a Database?

Creating barcodes with IronBarcode and storing them for Crystal Reports involves generating the barcode image and saving it to your database using a SqlConnection or OleDbConnection. Here is a complete example:

Imports IronBarCode
Imports System.Data.SqlClient

Module BarcodeGenerator
    Sub CreateAndStoreBarcode()
        ' Generate a Code128 barcode
        Dim myBarcode = BarcodeWriter.CreateBarcode("PROD-12345", BarcodeWriterEncoding.Code128)
        ' Add readable text below the barcode
        myBarcode.AddBarcodeValueTextBelowBarcode()
        ' Resize to appropriate dimensions
        myBarcode.ResizeTo(400, 150)
        ' Connect to your database
        Using connection As New SqlConnection("YourConnectionString")
            Dim cmd As New SqlCommand(
                "INSERT INTO Products (ProductCode, BarcodeImage) VALUES (@Code, @Image)",
                connection)
            cmd.Parameters.AddWithValue("@Code", "PROD-12345")
            cmd.Parameters.AddWithValue("@Image", myBarcode.BinaryStream)
            connection.Open()
            cmd.ExecuteNonQuery()
        End Using
    End Sub
End Module

Imports IronBarCode
Imports System.Data

Function CreateBarcodeDataTable() As DataTable
    Dim dt As New DataTable()
    dt.Columns.Add("ProductCode", GetType(String))
    dt.Columns.Add("Barcode", GetType(Byte()))

    ' Generate a barcode for each product
    Dim row As DataRow = dt.NewRow()
    row("ProductCode") = "PROD-12345"

    Dim barcode = BarcodeWriter.CreateBarcode("PROD-12345", BarcodeWriterEncoding.Code128)
    barcode.AddBarcodeValueTextBelowBarcode()
    barcode.ResizeTo(400, 150)
    row("Barcode") = barcode.BinaryStream

    dt.Rows.Add(row)
    Return dt
End Function

How Do You Display Barcodes in Crystal Reports?

Once barcodes are stored in your database, displaying them in Crystal Reports follows standard image field procedures:

1. Open Crystal Reports and create a new report or open an existing one

2. In Field Explorer, right-click "Database Fields" and select "Database Expert"

   

3. Connect to your database and select the table containing barcode images
4. Drag the barcode image field onto your report design surface
5. Resize and position the field as needed

Your report designer should look similar to this:

For dynamic barcode generation during report runtime, modify your DataTable or database query to generate barcodes on the fly. The following example shows how to bind a dynamically created DataTable to a CrystalReportViewer:

Imports IronBarCode
Imports System.Data

Function GetReportData() As DataTable
    Dim dt As New DataTable()
    dt.Columns.Add("ProductCode", GetType(String))
    dt.Columns.Add("Barcode", GetType(Byte()))

    Dim row As DataRow = dt.NewRow()
    row("ProductCode") = "CUSTOMER-12345"

    Dim barcode = BarcodeWriter.CreateBarcode("CUSTOMER-12345", BarcodeWriterEncoding.Code128)
    barcode.AddBarcodeValueTextBelowBarcode()
    barcode.ResizeTo(400, 150)
    row("Barcode") = barcode.BinaryStream

    dt.Rows.Add(row)
    Return dt
End Function

This approach generates barcodes dynamically when the report loads, eliminating the need to pre-store images in the database. You can export reports to PDF using Crystal Reports' built-in export features. For more information about Crystal Reports data sources, see SAP's Crystal Reports documentation.

How Do You Handle Common Barcode Printing Issues?

Several issues may arise when implementing barcodes in Crystal Reports using VB.NET. The following troubleshooting tips address the most frequent problems:

For additional troubleshooting support, visit the IronBarcode troubleshooting guide. The IronBarcode support forum is also available for specific questions and edge cases not covered in the documentation.

What Are Your Next Steps?

Implementing barcodes in Crystal Reports using VB.NET and IronBarcode provides a dependable solution for report enhancement. This SDK-based approach eliminates font dependencies while offering extensive customization options. Whether using a database or a DataTable, you can implement professional barcodes -- including Data Matrix, Code 39, and QR codes -- in your Crystal Reports application.

To continue building your barcode workflow:

• Download IronBarcode -- Get the free trial and start generating barcodes today
• Read the getting started guide -- Step-by-step setup for .NET projects
• Explore barcode generation examples -- Code examples for all common use cases
• Review supported formats -- Find the right barcode type for your application
• Check barcode reading tutorials -- Learn how to read barcodes from PDFs and images
• Visit the licensing page -- Compare plans for individual and team use

Start implementing barcodes in your project today by exploring IronBarcode's free trial to explore its full capabilities for printing barcodes in Crystal Reports using VB.NET. The SAP Crystal Reports SDK is documented at the SAP developer portal for additional integration patterns.