Get Tables and Fields in Crystal Rport Using Code

Introduction

Sometimes beginners in development fields struggle with Crystal Reports, so I hope this article will give them some kind of idea of what we can do using VB.NET or C# with Crystal Report.

Background

One of my friends wanted to create a solution where all the features are customized, like reports, forms etc. So he wants to make a solution to add a report dynamically to a system and give a benefit to user, create a selection formula by dynamically.

Using the Code

To start, we all know the .NET Framework is a big library with a collection of lots of things. Today Crystal Reports is one of part in .NET Framework (in earlier years it was not like that,[VB.6.0]). If you are beginner to .NET development hope using this article you can get an idea of how you can access Crystal Reports in your code. First of all you have to imports the following Class Libraries Imports Crystal Imports CrystalDecisions Imports CrystalDecisions.CrystalReports Imports CrystalDecisions.Windows

Dim i As Integer = 0
Dim j As Integer
Dim rptTets As New RPT_Invoice
'Dim rptTets As New CrystalReport -This is a Customized method

For i = 0 To rptTets.Database.Tables.Count - 1

    TreeView.Nodes.Add(rptTets.Database.Tables.Item(i).Name.ToString)

    For j = 0 To rptTets.Database.Tables.Item(i).Fields.Count - 1

        TreeView.Nodes(i).Nodes.Add("[" +
            rptTets.Database.Tables.Item(i).Fields.Item(j).Name + "," +
            rptTets.Database.Tables.Item(i).Fields.Item(j).ValueType.ToString() +
            "]")

    Next

Next

In here I used TreeView to load tables and fields, the first loop gets the all the table and second loop get the fields in side the table in the report.

All the comments are welcome.... Cheers