Hi,

I am using Crystal report 8.5 with VB6.
In order to implement a flexible reporting application.
I want my main application to pull all the needed data
using query and pass it to the rpt file, but my SQLquery
is not working as shown below. Please kindly assist. Thank you.



crRs.SQLQueryString = "SELECT item.plu, price.desc FROM d:\data\item,d:\data\price where item.plu = price.plu"

Crviewer1.reportsource = crRs
Crviewer1.ShowReport