>>>>I'm trying to open up a vfp5 dbc table in CR 4.5 but get an error message (free tables work). Anyone know what to do about this? Do I need an upgrade or patch, maybe?
>>>
>>>I haven't had any problems in either CR 4.5 or 5.0 using VFP 3.0. I use the VFP Database ODBC driver, not the VFP table driver. I saw a new VFP ODBC driver download available at the M$ VFP site. Hope this helps!
>>
>>Maybe you can answer a question before I proceed any further -- is it possible to run a CR report on a vfp view from within a vfp app? If I made the local view remote, maybe?
>
>Wish I could give you a direct answer on this, but I just started using CR about two weeks ago. I haven't tried using it from within VFP yet. I'm not sure this is true for CR 4.5, but in CR 5.0 there is an OCX that lets you call a Crystal Report from an application. According to the CR book, there are both 16 bit and 32 bit versions of the OCX (ActiveX). I am also using a CAD/CAM program that calls .rpt files generated in CR from within the application. You should be able to run CR against both local and remote views.

Thanks -- I guess the ultimate question is whether one can run a prebuilt CR report from within a vfp app on a Cursor (that may be asking a lot!). We just hired a contractor whose first job will be to investigate whether CR can do this, and perhaps look at other report generators like Foxfire as well, and compare functionality and aesthetics for them (including FPs own report writer)...I guess we'll want to look at CR 5, I hear that has fixed some 4.5 bugs.