Passing an ADO Recordset from VFP6 to Crystal Reports

[LeonelSanchezJr]

I am creating a record set with the following code and then I want to run a Crystal Report right afterward and have Crystal Reports use that record set. What code do I need to implement in between the following to parargraphs of code?

********************************************************
* code to create object and query sql
oAdo = CreateObject('AdoDb.Connection')
oAdor = CreateObject('Ador.Recordset')
oAdo.ConnectionString = [Provider=SQLoledb;data source= EGLStalDevSQL01;User ID =le;Password=;Connect Timeout=3]
oADO.Open
oAdo.DefaultDatabase = 'Talon_Dot_net'
Ador = oAdo.Execute("exec Hawb_SelectHawb 'TESTHAWBGES001'&quot



************************************************************
* code to preview Crystal report
oCRApp = createobject("crystal.crpe.application&quot
oRep = oCRApp.OpenReport("d:\leo\HAWB Air Waybill.rpt&quot
oRep.Preview
wait
***********************************************************


Thanks

 

[JDurbin]

Hmm I dont know I dont use Crystal but do you not need a Clientside recordset or can Crystal use a serverside one?
Do you have to set any reference to the ADO library in Crystal? Noone answered so I'm just throwing up guesses like a druken sailor after eating too much that nite John Durbin
john@johndurbin.com
MCP Visual FoxPro
ICQ VFP ActiveList #73897253

 

[TomasDill]

Hi!

Leonelsanchezjr, you need to look into the documentation for Crystal Repors or post this question to another forum. Your question is about functionality of the CR ActiveX object and ADO objects that is out of scope of this forum.



Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs