pass parameters to stored procedure

[gogetsome]

Hello, Can someone please show me an example of how to pass a parameter to a stored procedure? I have a crystal report that uses the stored procudure. I can call the procedure with this:


Set s = CreateObject("InternetExplorer.application")
s.Visible = True s.Navigate "

http://exchserver/scrreports/Service/Maintenance/maintenanceInvoice.rpt"

'?prompt0=" & JobStatus.Job & "&prompt1=" & CStr(Now)

Any help would be great!

 

[gogetsome]

oops, that should have been, I can call the report with:

 

[gogetsome]

Ok, I've come up with this so far but it is erroring out on the first parameter with "(objComm,parameters(...=<item cannot be found in the collection correspond...

here is where I am at the moment. Any help would be great!

Private Sub InvPrint_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)

Dim objCmd As ADODB.Command
Set objCmd = New ADODB.Command

objCmd.CommandText = "cssp_Maintenance_Invoice"
objCmd.CommandType = adCmdStoredProc
objCmd.Parameters("@invBeg").Value = "invBeg"
objCmd.Parameters("@invEnd").Value = "invEnd"
objCmd.Execute


Set s = CreateObject("InternetExplorer.application")
s.Visible = True
s.Navigate "

http://exch-server/scrreports/Service/Maintenance/maintenanceInvoice.rpt"

'?prompt0=" & JobStatus.Job & "&prompt1=" & CStr(Now)

End Sub