How to use crystal report with VB.NET by passing the SQL statement?

[badosoft]

How to use crystal report with VB.NET by passing the SQL statement?
Try to pass sql statement to a crystal report in vb.net 2008 after creating a dataset with it yet it will load the report but not showing the records, plsss help

[Hack]

Welcome to the forums.

Show us what you are doing, code wise, that isn't working.

[.paul.]

have a look at the dynamic crystal reports link in my signature

[badosoft]

I try to pass sql statement to a crystal report in vb.net 2008 after creating a dataset and added it to the crystal report as datacolumn with it yet it will load the report but not showing the records, pls help

' The Code on theform with button and crystal reportviewer
Public Class Form1

Dim objRpt As New ReportDocument
'Dim objRpt As New CrystalReportsException
'select staffid,surname,othernames,deptcode from stafftab imagepath Dim img As String = My.Settings.imagepath

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Using CCNN As New SqlConnection(My.Settings.bConn)
Dim sql As String

sql = "select staffid as Column1,surname as Column2,othernames as Column3,deptcode as Column4 from stafftab"

Dim dscmd As New SqlDataAdapter(sql, CCNN)
CCNN.Open()
Dim ds As New DataSet1
dscmd.Fill(ds, "stafftab")
objRpt.Load("Crstafflst.rpt")
objRpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = objRpt
CrystalReportViewer1.Refresh()
End Using
End Sub


Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim rptpathh As String = My.Settings.rptpath
Dim sDir As String = Directory.GetDirectoryRoot(Directory.Get… 3)
Dim sCurDir As String = Directory.GetCurrentDirectory.Substring(… 3) + rptpathh
Directory.SetCurrentDirectory(sCurDir)
Dim MDIParent1 As New MDIParent1
Me.MdiParent = MDIParent1.MdiParent
CrystalReportViewer1.RefreshReport()

End Sub