James

I read your question on crystal reports data refreshing (4-26-2001). I am having the same problem and wondered if you got it to work?

I save the Crystal Report with no data so it will refresh when loaded, but get the error, "Server has not yet been opened." The data is in a free table in VFP. I know I need to connect to the data source but am unfamiliar with the syntax of the SetLogonInfo() method. Here is the code I have in the init of my VFP form:



public CRApplication,CRReport
CRApplication = createobject ("CrystalRuntime.Application")
CRReport = CRApplication.OpenReport("X:\Report2.rpt")
thisform.oleCRviewercontrol.reportsource = CRReport
******************
* connect to testtable2.dbf here?
******************
thisform.oleCRviewercontrol.viewreport



Any help would be great!

Doug