How to run Crystal Report using Crystal Report Viewer in VS.NET 2005?

Following example developed in Visual Studio.NET 2005. In the following code we will see that how to use crystal report viewer in .NET.

Steps to use the crystal report viewer:-

Import the following namespace for sql server configuration settings.

Imports System.Data.SqlClient

'Code to configure the database settings

'Change the server="your server name where your sql server is running"

'database="Default" database "pubs" and sql "userid" and the "password"

Dim strConnection As String = "server=dtpxp-skumari;database=pubs;uid=sa;pwd=;"

Dim Connection As New SqlConnection(strConnection)

Dim strSQL As String = "Select * From authors"

Dim DA As New SqlDataAdapter(strSQL, Connection)

Dim DS As New DataSet

'Variable to assign the report name

Dim strReportName As String

' Create a datatable in your dataset. The datatable's name

DA.Fill(DS)

'Pass the reportname to string variable

strReportName = "CrystalReport2"

'Get the Report Location

Dim strReportPath As String = Application.StartupPath & "\" & strReportName & ".rpt"

'Check file exists

If Not IO.File.Exists(strReportPath) Then

Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))

End If

'Assign the datasource and set the properties for Report viewer

Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument

rptDocument.Load(strReportPath)

rptDocument.SetDataSource(DS.Tables(0))

rptViewer.ShowRefreshButton = False

rptViewer.ShowCloseButton = False

rptViewer.ShowGroupTreeButton = False

rptViewer.ReportSource = rptDocument