crystal 9 and parameters

[sexydog]

Hi

I have a report written in crystal 9 and i am using a stored proc from sql server 2000. my report orginally had 4 parameters in the stored proc and the report worked fine. i then decided to add 2 more parameters to the stored proc but now when i verify my database it comes up with the error saying that the stored procedured expects a parameter which was not supplied. what is the problem here and how can i solve it...

Thanks
DJ

 

[sexydog]

HI

Sorry this is my full error when i click on verify database in crystal reports 9:
Query Engine Error:'42000:[Microsoft][ODBC Sql Server
Driver] Procedure expects parameter which was not supplied

 

[checkai]

Get out of crystal, then open the report back up and rechoose it's database location. So basically find the same stored Proc and update it against your current one. That should update it fully.

DLC