Crystal Reports cannot access a VFP cursor. It can access VFP data in several ways:
- Fox2x tables, CR can use native access. With this method, the VFP program does all the data munging and SQL statements to collect the data, then creates the output data on disk.
- ODBC. This works just like ODBC to any data source. However, the Fox ODBC driver has not been updated for several versions.
- OLEDB. This works just like any OLEDB data source.
- ADO. The VFP application can create the ADO record source and pass it as a parameter to CR.
- XML. The VFP application does all the data munging and SQL statemens to collect the data, then creates the XML output file. CR uses ODBC to access this file.
There are several CR with Fox articles on my web site that may help you.
>I have never accessed data from a cursor in foxpro before.
>I must write a program that creates the cursor?
>How do I run the program from Crystal to get have the cursor formed and how do I access the cursor afterward.
>
>Thanks
>Jim
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer