>I am using Visual FoxPro 5.0 and Crystal Reports 5.0, I have selected (Filtered) Records which I want to pass to Crystal reports thru CR OCX, I am able to do it by passing the command
>
>thisform.cyrstal1.object.sqlquery = "Blah Blah"
>
>it works fine when the report and the queried list I want is restricted upto single table,
>
>But gets messy when it is related with multiple table by relationship..
>
>Am I using the right way...? Or can any one suggest me to get rid of this thing as such it is very important for me.... to give the reports of Queried (Filtered) List..
>
>Thanks and Regards


Run the query in VFP and save the results to a temp file on the disk, then have Crystal Reports report from that table.