I copied your message #
324845 to Roni Mordehi where you showed some code for calling a Crystal report from VFP6. To my delight I got that to work but I can not get the parameter portion to function. Do I need to have a section that performs my ODBC connection? I am using Oracle on the back end. I can uncoment the parameter area but it does not change the results of my report. I noticed that when I run the report from inside the report designer and do a refresh it prompts me to login to the server each time, thus my question about making a connection frist???? Thank you.
oEngineObject=CREATEOBJECT("Crystal.CRPE.Application")
oReport=oEngineobject.openreport("D:\50adev\rms\rpt\custrept\crtestrpt.rpt")
oReport.ParameterPromptingEnabled=.t.
oReport.PrintWindowOptions.HasRefreshButton=.t.
oReport.database.tables.Item(1).SetLogoninfo "oracle73",WSPD,WSPD (produces a systax error)
public rank
store ' ' to rank
@ 10,10 get rank pict '@!'
read
*!* set step on
*!* with oReport.ParameterFields
*!* for nt=1 to .count
*!* cname=.item(nt).parameterfieldname
*!* if type(cname) # "U"
*!* .item(nt).Setcurrentvalue(eval(cname))
*!* endif
*!* endfor
*!* endwith
oReport.preview
wait