hello sir ,

i am getting problem with crystal report
VB.net and SQL Server

i want selected values to be printed in crystal report
so i have written sql query for that .


dataset shows selected values but crystal report shows all data in database


Please help me .
following is th e code :-


Dim dacrupt As SqlDataAdapter = New SqlDataAdapter(strcryst, myconn)
myconn.Open()
dacrupt.Fill(dscryst, "t_candidates")
myconn.Close()
MsgBox(dscryst.Tables("t_candidates").Rows.Count)
str100 = "new resume"
Dim objcryst As New Form1
objcryst.Show()

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
CrystalReportViewer1.RefreshReport()
Dim myconn As SqlConnection = New _
SqlConnection("server=;database=project3;uid=;pwd=")
Select Case str100
Case "new resume"
newresume()
dscryst.Clear()
End Select
End Sub
Private Sub newresume()
Dim cr As New CrystalReport1
cr.SetDataSource(dscryst)

MsgBox(dscryst.Tables("t_candidates").Rows.Count)

CrystalReportViewer1.ReportSource = cr
End Sub

r u sure doing the right way when you make the report form at first time (using wizard).

This article has been dead for over six months. Start a new discussion instead.