Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending multiple value parameter from Visual Foxpro to Crystal Reports

Status
Not open for further replies.

INFORMAT

Programmer
Jan 3, 2001
121
BE
We want to send from Visual Foxpro a multiple value parameter to Crystal Reports. How can you do this?
 
Hi there,

I don't know what version of crystal reports you are using but on the RDC 8.5, you must define the parameters you want on the creation of the report, then within VFP you assign values to each of the parameters like this:

CRAplication=CreateObject("CrystalRuntime.Application")
CRReport=CreateObject("CrystalRuntime.Report")
CRREport=CRApplication.OpenReport("report.rpt")
CRParameters=CRReport.ParametersFileds.Item(x).AddCurrentValue(yyy)

Where x is the order number of the parameters you are assigning and yyy is the value if it is a string must be placed between quotes.

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top