>The following code works perfectly to refresh the data & preview my report, in Vbasic...
>
>Dim CrystalApplication As CRPEAuto.Application
>Dim CrystalReport As CRPEAuto.Report
>Dim DbName As CRPEAuto.Database
>Dim DbTables As CRPEAuto.DatabaseTables
>Dim DbTable As CRPEAuto.DatabaseTable
>
>Private Sub Form_Load()
>Set CrystalApplication = CreateObject("Crystal.CRPE.Application")
>Set CrystalReport = CrystalApplication.OpenReport("C:\Program Files\Seagate Software\Crystal Reports\A.rpt")
>
>Private Sub CmdPrintReport_Click()
>Call CrystalReport.DiscardSavedData
>Call CrystalReport.Database.Verify
>CrystalReport.Preview
>End Sub
>
>!!!THE EQUIVALENT FOX CODE listed below DOES NOT!!! WHY!??!
>
>LCrwApp=Createobject('Crystal.CRPE.Application')
>LCrwRep=LCrwApp.OpenReport("C:\Program Files\Seagate Software\Crystal Reports\A.rpt")
>LCrwRep.DiscardSavedData
>LcrwRep.Database.verify
>LcrwRep.Preview
>
>ARE WHY WE GOING TO ADMIT TO ANY SUPERIORITY IN VB?!!!
Ken,
That code runs perfectly on my system (of course .rpt name is different). Are you using ODBC ? If so might that be the problem ? What I do is to create report with some data, then at runtime SQL select into a cursor, copy to ... type fox2x, change Crytal.report.tables.location and preview. Works well.
Cetin