Crystal Report in VS2005 (VB)

 
In VS2005 (VB), First you have to create a crystal report (say CrystalReport1) and add a crystal report viewer (say CView),
then the code behind is given below.
 
Dim dataSet As DataSet
Dim crReportDocument As CrystalReport1
Dim Con As SqlConnection
Dim Da As SqlDataAdapter
Dim conn As String = "Server=<server name>;Database=<database name>; User ID=<user name>;Password=<password>"
Con = New SqlConnection(conn)
Dim sqlString As String = "<sql string>"
Dim cmSQL As SqlClient.SqlCommand
cmSQL = New SqlClient.SqlCommand(sqlString, Con)
Con.Open()
Da = New SqlDataAdapter(sqlString, Con)
dataSet = New DataSet()
Da.Fill(dataSet, "<dataset name>")
crReportDocument = New CrystalReport1()
crReportDocument.SetDataSource(dataSet)
CView.ReportSource = crReportDocument
Con.Close()