Has anyone ever come across integrating crystal report with vip ver 5.5. Specifically pass a parameter to a crystal report via crystal report property called ParameterFields? I followed the way we do it in VB but could not work.

VB:
With cryReport
.WindowState = crptMaximized
.Connect = 'DSN=servicename; UID=userid; PWD=pwd; '
.ReportFileName = 'report.rpt'
.ParameterFields(0) = 'prmVal1; test; true'
.Destination = crptToWindow
.Action = 1
End With

VIP:

CrystalReport.Connect = 'DSN=servicename; UID=userid; PWD=pwd ;'
CrystalReport.ReportFileName = 'report.rpt'
CrystalReport.ParameterFields(0)= 'prmVal1; ' + $TEST + '; TRUE'
CrystalReport.WindowState = '2'
CrystalReport.Action = 1

the above fields compiled and return error on the parameter line. i then changed so that the parameter passing part looks like this

CrystalReport.ParameterFields = 'prmVal1; ' + $TEST + '; TRUE'

however when it comes to run time crystal report did not manage to get the parameter.

anyone got any idea...thanks

We have not tried this with Crystal Reports but we do pass parameters to stored procedures. I suspect that passing parameters to Crystal may be similar. There are some previous posts on stored procedures. Check them out.

Bill.

Due to proiv lack of a professional report writer, I interfaced to delphi a few years back & used the crystal VCL to produced reports, I know the syntax is roughly the same so try this :

Crpe1.ParamFields[0].CurrentValues.Add(PARAMSTR(6))

paramfields (n) is the sequence in your paramater fields

& i just pass command line paramters from proiv.

Hope this helps

Peter