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