Hi,

I actually have reports (donw using Crystal reports 8.5) that is up and running using MSSQL 2000 connected via ODBC. Datasource is an MSSQL stored procedure.
Now, we have an old version of our application that was done using Visual Foxpro 6 and is still using Foxpro database and tables.
All the table structure here is exactly the same (including fieldnames and table names) to our MSSQL database.
The new version is using crystal reports while the old one was using foxpro reports. I wanted to have a way of making our Crystal Reports work on the old version.
Since the new reports (crystal) is having MSSQL as datasource, I wanted to know if it's possible that at runtime I can chance the datasource to point to another datasource (foxpro). Since fieldnames and table names are the same, I'm thinking that I will not have a problem with the report objects at all and won't need to remap the report fields.
Inside the application, I have a cursor which is actually containing data from a SELECT...FROM...WHERE...statement. Just like the MSSQL stored procedure statement we are using on the new reports done with crystal.
Is it possible to change the crystal reports datasource from MSSQL to FOXPRO (cursor)?

If the answer is yes, please guide me how to do this. If no, please show me possible workarounds.

Thanks a lot,

Jay