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).

how can filter the field in crystal report at run time in vb.net

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.