You can't pass cursors to Crystal Reports because they exists in FoxPro's memory space. You have several choices:
- Copy the cursors to Fox2x tables. Crystal can read these natively
- Use ODBC to pull the data from VFP tables
- Use ADO to pull the data from VFP tables
- Copy data to XML files. Crystal can read these through it XML ODBC driver
>Hi there,
> I am going to start using Crystal Reports as my primary report designer. However I am not sure how to pass VFP Cursors to reports. Can anyone please explain to me step by step what needs to be done from the VFP and from the Crystal side. Then when I installed my application at a client site should I set up some ODBC connections or anything else ??? Or does anyone have another good reporting tool which can be easily integrated in Vfp which have good exporting functionality.
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer