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!

parameters error when open Crystal Report

Status
Not open for further replies.

NatashaM

Programmer
Apr 29, 2002
9
US
Hi all,
I created several Crystal reports using the stored procedures. Some stored procedures have parameters. When I open the report from VB without any stored procedure parameters after the report with parameters I got run-time error 20553 "Invalid Parameter" or an error 20532 "Table is not a stored procedure". And I don't get any errors if open reports with SP parameters or only without parameters. Please HELP!

I use this code :
Case 0
Me.CrystalReport1.ReportFileName = "Accepted Deliverables.rpt"
Me.CrystalReport1.StoredProcParam(0) = Format(strBegin, "yyyy-mm-dd") & " 00:00:00.000"
Me.CrystalReport1.StoredProcParam(1) = Format(strEnd, "yyyy-mm-dd") & " 00:00:00.000"
Me.CrystalReport1.Destination = 0
Me.CrystalReport1.Action = 1

Case 1
Me.CrystalReport1.ReportFileName = "Rejected Deliverables.rpt"
Me.CrystalReport1.Destination = 0
Me.CrystalReport1.Action = 1

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top