Cryastl Reports is not recognizing that a new parameter has been added to the report's stored proc

i have added another input parameter to a stored proc used by a crystal report. i've had our dba recompile the stp to be sure that the new parameter is cached and "really there".

i cannot get my crystal report to recognize the new parameter -- i've tried verifying database and using the Set Datasource Location/Update to re-select the stp.

i'm using cr11 against a 20开发者_如何学JAVA05 sql server db.

any other suggestions?

right click stored procedure click verify database then Press Cancel Button that will do the trick...^^

I'd try these in order:

1) verify the database, then test for new parameter
2) check using sql server management studio that the parameter is really there.
3) close crystal reports and reopen & verify database, then test for new parameter
4) close crystal reports remove data source, add data source back, and reopen crystal & verify database, then test for new parameter
5) reboot and then try #3

Have you tried removing and adding the data source?

Usually verify DB works, but have had a couple cases where I had you remove and add again.