1 Attachment(s)
Help me pls ! error in VB.Net connection false to Crystal Report XI
Hi,
I will do project VB.Net 2003 ,I have error runtime but i don't know it's mean.
I wan't query sql show in CrystalReportViewer . But is error
Somebody please help with the code or a way of fixing this problem.
Code
Dim report As New Report1
Dim SqlString As String = "SELECT * FROM TBL_FJT_TEST WHERE ID_LOT_NO ='" & dmRow_Id & "'"
CrystalReportViewer1.ReportSource = report
Dim dt As New DataTable
Dim da As New SqlDataAdapter(SqlString, conn)
da.Fill(dt)
report.Database.Tables(0).SetDataSource(dt)
CrystalReportViewer1.ReportSource = rpt1
Re: Help me pls ! error in VB.Net connection false to Crystal Report XI
I have done various kinds already but I can not .
How to do ?
Code Use dataset
Dim myDa As New SqlDataAdapter( _
"SELECT * FROM TBL_FJT_TEST WHERE ID_LOT_NO ='" & dmRow_Id & "'", _
northwindConnection)
Dim ds As DataSet
myDa.Fill(ds, "TBL_FJT_TEST")
rpt1.Load(Application.StartupPath & "/Report1.rpt")
rpt1.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rpt1
Re: Help me pls ! error in VB.Net connection false to Crystal Report XI
Welcome se_juneke :afrog: :wave:
Is the DB available at the location supplied to the CR
Re: Help me pls ! error in VB.Net connection false to Crystal Report XI
Quote:
Originally Posted by VBFnewcomer
Welcome se_juneke :afrog: :wave:
Is the DB available at the location supplied to the CR
Thanks you.
I don't know location paste where DB of CR
do you have Example for me..
please.....:cry:
Re: Help me pls ! error in VB.Net connection false to Crystal Report XI
He means is the database located where Crystal Reports is being told it is located.