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.
'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
Comments