Urgent! Problems with stored procedure parameter.

[antihippy]

Guys,

I need your help.

I've been running some reports based upon stored procedures in MS SQL server. The problem is that a new parameter has been added to these stored procedures and when I refresh the data (get prompted for new values) the report doesn't have them listed in the stored procedure and fails when it attempts to run. The error message says [report] " ... expects parameter@apptype, which was not supplied." The paramter for this report are:

@startdate - should be start of month
@enddate - should be end of month - this is the new parameter

So,

Is there any way I can get these reports to pick up the new parameters - without having to reformat all of them?

Your help would be greatly appreciated. I'm using Crystal Reports 8.5.
@apptype - this is a whole number.

 

[synapsevampire]

Not sure what you mean by reformat all of the reports, but if you open the designer and select Database->Verify Database, the reports will now pick up the new parms.

-k

 

[antihippy]

Cheers,

I was trying to be as verbose as possible. When I mentioned reformat - I was really meaning redo.