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

See the following links. Hope it will help you.

http://systems.bus.ucf.edu/lwest/cou...ns/reports.htm

http://www.vbdotnetheaven.com/Upload...thXmlInVB.aspx