Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports and VFPOLEDB
Message
From
06/02/2002 11:27:55
Pamela DeMerchant
Eagle Global Logistics, Inc.
Houston, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Crystal Reports and VFPOLEDB
Miscellaneous
Thread ID:
00616103
Message ID:
00616103
Views:
69
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
Map
View

Click here to load this message in the networking platform