>Hi All,
>
>My application uses Crystal Reports 8.5 RDC displaying the report in a VFP 7 form. I have converted the .rpt to use the new OLE DB VFP driver instead of an ODBC DSN, but have not yet successfully been able to set the data to use the new driver programmatically. Any help would be appreciated from someone who's been there.
>
>Thanks,
>
>Pam
>
>
>goCrxRp = Createobject("CrystalRuntime.Application")
>goRp = goCrxRp.OpenReport(c:\TestCrystal\Reports\Test.rpt)
>oConn = CREATEOBJECT("ADODB.Connection")
>oConn.Open("Provider=vfpoledb.1;Data Source=c:\TestCrystal\data")
>oRS = CREATEOBJECT("ADODB.Recordset")
>lcTestData = "Select * from Test"
>oRS = oConn.Execute(lcTestData)
>goRp.Database.SetDataSource(oRS)
Is there an error message?
Maybe if you set oConn.CursorLocation = 3 && adUseClient. (depends on what CR requires)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement