Skip to Content
0
Former Member
Feb 16, 2011 at 04:25 PM

Problem Passing A Parameter to SQL Server Stored Procedure

695 Views

I have a report from which I want to execute a stored procedure. I have added the stored procedure through the Database Expert and my data source. After doing so the parameters are automatically created in Crystal. However, when the report is run the stored procedure does not execute. So if I modify my stored procedure to run without parameters and add to crystal then it executes. So I know the SP can be executed from Crystal. I have one string parameter and one date parameter that I want to pass. Recognizing dates may be a little more complicated I have modified the SP to just take one string paramater for now. It still does not work - as soon as I add a parameter the SP does not execute from Crystal. Remove the parameters and it works fine.

I am not even sure how to troubleshoot this. Trying to find an answer on the forum or other and have not yet found anything particularly helpful.