Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Crystal 8 and ODBC
Message
 
À
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Crystal 8 and ODBC
Divers
Thread ID:
00354419
Message ID:
00354419
Vues:
73
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform