You should be able to just make a new ODBC connection to the VFP data and then change the DSN in the report.


>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