Hello Craig,

I followed your article ( Using Crystal Report with VFP ). It is a great start!.

I have the following need :

I created a report in Crystal with one parameter ( date ) and I ran it using the example from your article. I am able to preview the report and print the report. The problem is that everytime I refresh the data by clicking the refresh button on the toolbar and then typing the date for the parameter I get the following message :
"Server has not yet been opened"

How do I refresh the data ( SQL SERVER )?. Is there any example that can show me how to accomplish this?. Where I can look at all the properties and methods available for the Viewer.

The database is a SQL Server.

The code that I used from your article is the following :

WITH Thisform
      * Instantiate Crystal Runtime 
      * and add the report viewer to the form
      .oCrystalReports = CREATEOBJECT("CrystalRuntime.Application")
*      .oReport = .ocrystalreports.OpenReport("C:\temp\Cust.rpt")
      .oReport = .ocrystalreports.OpenReport("r:\DailyCashReceipt_withownview.rpt")      
      .AddObject("oleCRViewer", "oleControl", "crViewer.crViewer")      

      WITH .oleCRViewer
            * Set report viewer properties
            .Top = 1
            Left = 1
            .Height = ThisForm.Height - 2
            .Width = ThisForm.Width - 2
            .ReportSource = ThisForm.oReport
            *.EnablePrintButton = .F.
            .ViewReport()
      ENDWITH
ENDWITH

Thanks,

Sergio