>>Thank you for your guidance Randy. I just got Crystal Report today.
>>
>>To recap your thought, I should:
>>1. Gather the required data thru the existing SQL statements
>>2. Hold the results into a temporary table, that can be released when the >report is exited.
>>3. Design a report using Crystal Reports to present the information to the >user.
>>
>>Am I consistent with what you are telling me? Thanks again.
>>
>>- Ravi
>
> That's basically it. You will have to SELECT .. INTO CURSOR xxx and then COPY xxx TO yyy TYPE FOX2X. In Crystal you will open the data file under 'Database Files'. Check the archives here, you will find a sample program for actually calling and displaying the Crystal report from within your VFP app.
> You can certainly use the ODBC driver directly on the VFP DBC, and generate the SQL query in Crystal, it works fine, but the downsides are it's slower and you have to configure the ODBC connection on every user's computer. If you're moving from the native Foxpro report writer, then you no doubt already have the logic in place to generate the required queries, so why reinvent the wheel?
>
>
> Randy

Thanks Randy. This makes a lot of sense. Will post a new thread if I run into any problems.

And to all at UT. This is the best place for advise. Thank you all!

- Ravi