>Another option to ODBC is using FOX2X tables. In my apps, I do all the work in VFP to get the result set the user requires for a report and put the result set in a FOX2X table, which CR can access natively, for Crystal to run from.

That solves two problems at once. The CrystalReport ActiveX control is much easier to use with a report on Fox2x tables, and the report takes much less time to gather data into the report. There might be some reason why this isn't possible though, like too much data to dump into a local cursor maybe?