我的水晶报表(crystalreport9.0)数据库字段来自三个表,传递数据的代码用一个sql查询语句来完成,由于没有经验,不知这样写对不对,请各位高手指点!
Dim capp As New CRAXDRT.Application
Dim carp As New CRAXDRT.Report
Dim CRXD As CRAXDRT.DatabaseFieldDefinitionPrivate Sub Command1_Click()
dim sql as string
Set carp = capp.OpenReport(App.Path & "\BookInfo.rpt")
sql="select * from Maintb,Detailtb,Detailtb1 where LOTNO='"&trim(txtLOTNO.text)&"'"
rs=cn.exe(sql)
carp.Database.Tables(1).SetDataSource rs
carp.ParameterFields.GetItemByName("CR").AddCurrentValue (Text1)
CRViewer91.ReportSource = carp
CRViewer91.ViewReport
End sub
Dim capp As New CRAXDRT.Application
Dim carp As New CRAXDRT.Report
Dim CRXD As CRAXDRT.DatabaseFieldDefinitionPrivate Sub Command1_Click()
dim sql as string
Set carp = capp.OpenReport(App.Path & "\BookInfo.rpt")
sql="select * from Maintb,Detailtb,Detailtb1 where LOTNO='"&trim(txtLOTNO.text)&"'"
rs=cn.exe(sql)
carp.Database.Tables(1).SetDataSource rs
carp.ParameterFields.GetItemByName("CR").AddCurrentValue (Text1)
CRViewer91.ReportSource = carp
CRViewer91.ViewReport
End sub
我的开发环境:VB6.0+Access+crystalreport9.0
//完全可以,它会自动接受recordset中间对应的名称和类型字断。
你的SQL怎么写是你的问题