Hi,
Why do my sql query string is not working as the report preview is giving me
empty field. I had try putting the using the SQLQueryString. Please kindly advise
My code is
Dim crApp As New CRAXDRT.Application
Public crDB As CRAXDRT.Report
Private Sub Form_Load()
Dim lStr As String
Set crDB = crApp.OpenReport("d:\temp\report3.rpt", 1)
lStr = "Select item_master.plu, inv_journal.subplu1," & _
"inv_journal.request_no from" & _
"d:\winprog\winpos\data\item_master.dbf," & _
"d:\winprog\winpos\outlet\inv_journal.dbf" & _
"where item_master.plu = inv_journal.plu"
crDB.SQLQueryString = "Select item_master.plu, inv_journal.subplu1 from d:\winprog\winpos\data\item_master.dbf,d:\winprog\winpos\outlet\inv_journal.dbf"
'crDB.Database.SetDataSource lStr
CRViewer1.ReportSource = crDB
CRViewer1.ViewReport
Best Regards
Virusim