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
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