>If I pass parameters from a VFP form to Crystal Reports report, does that mean that I also have to do record selection in VFP and pass that too or can I leave record selection in Crystal Reports as-is?
>
>Thanks for the info. I plan to call Crystal Reports this afternoon for answers to some of these questions. I will post their answers here.
Since the latter didn't happen, here's my experience.
Passing parameters to CR means you are letting CR pull the data for you. Now what data are we talking about? If it's SQL server or any other DB server, CR may or may not be better than VFP in pulling data from there. But if it's VFP tables that we're talking about, CR is most probably pulling the data using ODBC driver... which can't possibly be faster than doing the same thing from VFP and handing it to CR.
The common technique I was using (while I had CR in my job description) was to do all the heavy data crunching and munching in VFP, have the denormalized data in a cursor, copy the cursor to a temp table type fox2x, and then tell CR (via thisform.crystalobject.datafile(0)={path to table}) to use that for the main report, and repeated it for subreports if need be.
Worked like a charm, even on slower machines. When it was slow, it was the SQL which was too complicated etc, and was fixable within VFP.