Sounds good.... I'll let them know.

Thanks!

>You can't report off VFP databases without using the ODBC driver, thus a DSN on each machine. However, the copy files to FOX2X type method works quite well - all data selection can be done in VFP, the report then simply displays the fields with no processing. The way I did this was to handle the select logic in VFP and copy the resulting cursor to a FOX2X table in a temp directory. Each workstation has the same temp directory structure so the report runs on any machine. By doing this, the same report can be used for production or test data, it doesn't matter - the report generates from the temporary file, the contents of which are controlled by the VFP app, so that is where you decide to pull from production or development.
> If you use the ODBC driver, you CAN programmatically change which DSN is being used. Look at the LogOnServer and SetLogOnInfo methods in the RDC. You can create the report using an ODBC datasource pointing to development data, but in the production app point the datasource to the production DSN when calling the report.
>
> HTH,
> Randy
>