Stored Proc params

[ShortyA]

Hi,
I am running CR XI against SQL Server 2000 connecting via OLE. I have an existing stored proc, called "MySP" which has 2 parameters. This stored proc has been cloned to "MyNewSP" and has 2 further parameters.

When I try to use "Set Datasource location" in CR to point to the new SProc it prompts for the old params but not the new. How can I get CR to pick up the new params ?

Many thanks - ShortyA

 

[synapsevampire]

It should do so...

Try resetting it to ODBC first, then back to OLE DB.

It sounds as if you're pointing at the wrong SP.

-k

 

[ShortyA]

Hi synapse...
worked beautifully! I also found another "workaround" where the orig SP is cloned to "MyNewSP", the report is pointed to that, then the SP is changed to bring in the new params and THEN do the Verify Database.

Thanks as always!

ShortyA