How do I replace another stored procedue with out doing another one from scratch

[satyakumar]

Hi Folks,


I have a quick question. I wanted to replace a Stored procedure in Crystal reports 2008 with another one. The new SP has the same column names etc... So with out creating a new .rpt file is it possible to replace in Crystal itself. Please let me know.


Thanks
Satya

 

[hilfy]

Have you tried using Set Datasource Location? That should do it for you.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[satyakumar]

I don't think Set Data source location will work. It will work only when we wanted to migrate from DEV to INT and to PROD. It will not work for replacing the stored proc....

 

[Turkbear]

An experiment is better than 1000 theories, so have you actually tried the change datasource option?



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kray4660]

I know from practice that CR can be a little funky if the database is the same name but on another server. I think we had to go to each table and re-point to the new location. I am not sure how a SP would work.

 

[crystalkiwibruce]

A Stored Procedure is a oommand inside the database. It performs some SQL and returns some data.

If a similar Stored Procedure is in the other database you can use "Set Location" to select the other procedure. The name inside the report will stay as the original name, but you can rename the table using F2 (rename) inside the Database Expert.

A SQL Command does something similar but is SQL stored inside the Crystal Report. You can change a report from one database to another, by copying and pasting the SQL Command Text to a new SQL command and then using Set Location to the new SQL Command. Slightly more keystrokes and a little fussy about what you can and can't do there.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm