Hello there, I need some help on the following please.
I am using Excel97 VBA to open and print a pre-made crystal report saved on the HD, got this bit to work OK. The problem is I can't figure out how to connect to the oracle database so that I can pass parameters to the stored report to change the values on the printed report. I have tried the following code but although it does not display an error it just prints blank reports.
Dim app As New CRAXDRT.Application
Dim rpt As CRAXDRT.Report
Set rpt = app.OpenReport( App.path & "\2006.rpt")
rpt.ParameterFields(1).AddCurrentValue 1015283
rpt.Database.LogOnServer "crdb_oracle.dll", "Oracle SID", "", "username", "password"
rpt.PrintOut False, 1
I am using Excel97 VBA to open and print a pre-made crystal report saved on the HD, got this bit to work OK. The problem is I can't figure out how to connect to the oracle database so that I can pass parameters to the stored report to change the values on the printed report. I have tried the following code but although it does not display an error it just prints blank reports.
Dim app As New CRAXDRT.Application
Dim rpt As CRAXDRT.Report
Set rpt = app.OpenReport( App.path & "\2006.rpt")
rpt.ParameterFields(1).AddCurrentValue 1015283
rpt.Database.LogOnServer "crdb_oracle.dll", "Oracle SID", "", "username", "password"
rpt.PrintOut False, 1
