SQL Stored Procedure

[bstreet]

When I try to pass a parameter using a Stored Procedure I get an error message saying parameter value was not supplied. Is there a way I can use parameters in a stored procedure?____Thanks__Butch__;)

[kfleming]

Are you using RI_REPLACE to pass the parameter?____Kathleen__R&R Support

[bstreet]

Kathleen,__I have an RR report based on a stored procedure, the stored procedure is set up to require paramaters. I need to pass these paramters into the stored procedure. So when I run my report can I pass a paramater to the stored procedure so I can get the result set I need.____

[kfleming]

You would need to put the parameter in double brackets in the saved report__EXEC MYPROC <<param1>>____At runtime you would then use RI_REPLACE to set the value of param1__for example:__RI_REPLACE=KANSAS____will do an __EXEC MYPROC KANSAS____Kathleen__R&R Support