>>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?
Are there some tricks to using the ActiveX control? I've done some testing using it and I keep getting intermittent OLE errors. The control still works and displays the report but the errors are annoying.
I've been using OLE Automation of Crystal instead but the nice advantage the ActiveX control has is that it's contained in a VFP form.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.