Crystal from VFP

[DanNorris2000]

Please do not point me to the Craig Bernston article. It offers nothing to me.

Crystal 8.5
VFP 6.0
Error: OLE IDispatch exception code 20599 from CPEAUT32: Cannot open SQL server.


Just trying to call a Crystal report with parameters from within a VFP program from a command button in VFP.
using the following code:
oCRAPP = createobject("crystal.crpe.application&quot
oRep = oCRAPP.openreport("k:\vfp\reinsurance\reports\35pf.rpt&quot
oRep.printout(.f.)

The problem is that this work on some reports and not others

 

[hoosier121]

Hi DanNorris2000,

Creating the report object this way is the old way, since you have 8.5 you could use the RDC.
oCRAPP = createobject("crystal.crpe.application&quot

Here is an FAQ on the subject...
faq184-3039
John

Everything I needed to know I learned from Yoda.

 

[DanNorris2000]

That particular FAQ refers to VFP 7.0. Will it work with 6.0?

 

[rgbean]

Dan,
While I'm no CR expert, I can say that there doesn't appear to be ANY VFP 7.0 specific code in that FAQ - it should work in VFP 6.0 (at least SP 3->).

Rick