Change Stored Procedure name

Hello,

I want to change the name of a stored procedure. Does anyone know how I can do this?

If I simply change the name and repoint the report, the report thinks it's looking at an entirely new SP and so discards all the existing fields.

Any help would be great.

Thanks.Open the report and Do verify Database and save the report|||That won't work because the variables from the old SP are fully qualified.|||Hey

Under Database menu --> Set Location
Edit the SP's name in the Table field and it shouldnt toss ure
fields.

If u need..u can change the alias of the SP in Crystal to the new 1 also.
Cuz in CR8 the alias aint updated when u change the SP.

Hope this helps.|||Nice one.

Thanks.