>First of all, thank you to everyone who has helped along the way.
>
>Currently, I am trying to write a program that will allow users to create and edit reports on the fly. I am using VFP 5.0. I had originally wanted to incorporate Foxfire! into the program, but I am now forced to use Crystal Reports version 7. I admit I have not even installed Crystal Reports on my machine yet, but from looking through the manual and VFP's help files, I have not been able to figure out how I am going to call the reports created in Crstal Reports from VFP. If anyone can give me any info on this at all, and I have the utmost confidence you will be able to, I would greatly appreciate it. This whole project has been a nightmare as far as trying to incorporate a report writer and the sooner I get it done, the happier I will be! Thanks in advance,
>Jason Mower


There are two issues that you need to consider. The first is providing the data to Crystal Reports. You can provide the data in two ways. Crystal can issue a SQL SELECT statement using the VFP ODBC provider. The second way is to run a program in VFP that creates a FOX2x table with data just for the report. Crystal can read FOX2x tables without using ODBC.

The second issue is launching Crystal Reports. There are a couple of ways you can do this. The first is to use the ActiveX control. Drop it on a form and set some properties. The second is to use the automation server. You create an instance of this with CREATEOBJECT().

VFP documentation will not tell you specifically how to handle the crystal report. There will be documentation with CR that will show you how to do all this in VB.