General information
Title:
Crystal Reports and VFPOLEDB
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)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only