>I am accessing a foxpro database via ODBC out of Crystal Reports (v 6) on a Win95 machine, my database resides on a NT server. The response is decent.
>
>When I access the same report, same data, on the same machines with the same DSN out of my VFP 5.0a program which uses the Crystal Reports OCX control, speed is dismal.
>
>I am stumped as to why there should be a difference in speed. Any and all suggestions are welcome.
Probably a difference in how Crystal handles things in the designer as opposed to the OCX. I use a PRG in FoxPro to create a report table that has all the data needed for the report, then save to a FOX2X table. Crystal can read this natively. This means no ODBC setup, less support, and much more speed.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer