Add additional parameter to stored procedure

[hockeypuck]

I am using SQL and already am accessing a stored procedure through CR and am passing several parameters. I want to add another parameter (@sales_rep). So I added the parameter to CR and to the stored procedure as well. The value is not being passed to the stored procedure even though I have verified that it is correct in CR. Is there something I need to do to 'link' the CR parameter to the stored procedure?

Thanks
Dave (hockeypuck)

 

[skuhlman]

When you add the parameter to the stored procedure it should automatically be added to the crystal report. You may need to "verify database" in the crystal report to make it happen. Once you've done this, you should see that the parameter you placed in the SP has been added to your parameter list. You don't need to add another one to the crystal side. Make sure that you enter the value in the @Sales_Rep parameter that the SP passed to crystal, and you should have no problem geting the results you want.

 

[hockeypuck]

Skuhlman,

thanks for the tip. worked great!!!

hockeypuck