Jump to content


Photo
- - - - -

Crystal Report parameter


2 replies to this topic

#1 Albert Ho

Albert Ho

    Member

  • Members
  • PipPip
  • 19 posts
  • Gender:Male

Posted 14 January 2003 - 10:24 AM

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

#2 Bill Loven

Bill Loven

    Expert

  • Members
  • PipPipPipPip
  • 147 posts
  • Gender:Male
  • Location:Coppell, United States

Posted 14 January 2003 - 03:15 PM

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.

#3 Guest_PETER TERRINGTON_*

Guest_PETER TERRINGTON_*
  • Guests

Posted 15 January 2003 - 10:42 AM

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



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users