>I am thinking about using Crystal Reports in my VFP application. Has anyone had any success using Crystal Reports or am I better off sticking with the Office Automation?

The VFP DevCon 2001 keynote session included a detailed demo of Crystal Reports 8.5 working with VFP 7.0, controlled via automation and using the new VFP 7.0 COM event binding to call VFP while the Crystal report was running, and also how to use the new VFP 7.0 OLE DB provider to access VFP data directly from Crystal Reports. See the keynote demo online at http://msdn.microsoft.com/vfoxpro