Hi, Don,

Thanks for the info. I never did full speed tests of all the methods, so I don't know which is 'fastest'. Here's a stripped down version of the steps we used in our VFP6 app..

- Let's say someone wanted to run a report of invoice history for 3 customers
- We'd do a query against the invoice tables for the 3 accounts, and at the end copy the query contents to a temporary location on a user's machine (or a network drive if they were using Citrix). The copy would create Fox2x tables
- We'd use the SetTableLocation functions when we loaded Crystal, to tell Crystal where the runtime files existed.

It worked very well and we never had any real performance problems. That worked faster than using ODBC and reporting directly against the database tables. Most of our users were running reports 20-25 pages or less. I'd say the most intensive part was the querying against the database.

We used that approach for years until we re-wrote the app in .NET, and now we're using nothing but DataSets/XML for reporting.

Hope that helps...
Kevin