oCR = CREATEOBJECT("CrystalRuntime.Application")
oRpt = oCR.OpenReport("C:\EFox\ODBC1.RPT")

* Create the Database object
oDB = oRpt.Database()

* Get a references to the DatabaseTables collection
ocDBT = oDB.Tables()

* Get a reference to the DatabaseTable object for table 1
oDBT = ocDBT.Item(1)

* Set the location
* This one works for a DSN
oDBT.SetLogOnInfo("TazODBCRuntime")

* This will disard the saved data
IF oRPt.HasSavedData
  oRPT.DiscardSavedData()
ENDIF

oRpt.PrintOut()

>Hi All,
>
>I retrieved data mysql and dump to a dbf file. And use odbc connection to crystal report for printing. However I found that the report can not displayed the updated record, and I need to click the refresh button. Is there anyway to make it auto refresh by setting or coding?
>
>regards
>Kusnardi