Jim,
U can make your life a little simple by doing the following steps.

a) First step, Check your Windows ODBC settings for this particular ODBC. Check if the data path given is correct? (this can be a prblm area)

b) Open your report in CR8. Execute at first instance? If this gives error - Log on/off Server - load your ODBC and try executing again? This should work ?
U can verify your database for changes and save the report.

c) Add Activex, Crystal Report Control on your form. (i am presuming u kown to add a activex control)

d) Now in the command button click event add the following code

Thisform.Olecontrol1.ReportFileName="c:\foxdat\locationcdrive.rpt"
Thisform.OleControl1.Action=1

COOL isn't it !! First time u will have little difficulty but it will only be for the first time. BOL Jim!!
U can reach me at shams201@yahoo.com or sanjaypatel@india.com

sanjay


>Help Please,
>
>I'm trying to get my first CR report to print out of a vfp6.0 form
>
>***this line is in the load event of my vfp6.0 form.
>sys(233,1)
>
>***this code is in the click of the command button.
>public CRApplication
>public CRReport
>CRApplication = createobject("crystalruntime.application")
>CRReport = createobject("crystalruntime.report")
>
>CRReport = CRApplication.openreport("c:\foxdat\locationcdrive.rpt")
>ThisForm.Olecontrol1.reportsource = CRReport
>ThisForm.Olecontrol1.viewreport
>***end of code
>
>
>When the CR opens I keep getting this message "Server has not yet been opened"?
>
>I added code in the load event to use the table and it still didn't work and all the necessary .dll's are already in my system32 folder.
>
>This report was created on my developement pc, windows 2000.
>
>Any ideas would be appreciated.
>
>Thanks,
>
>Jim Harvey
>jharvey@netrax.net