INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...it was ingeniously designed and all those clicks were for my own good... and that was even before I got my speedy and useful answer to my tekkie question that I eventually posted..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 4 Other topics Forum

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

Read More Threads Like This One

satyakumar (Programmer)

10 Jul 12 16:36

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 ( IS/IT--Management)

10 Jul 12 16:50

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
www.decisionfirst.com

satyakumar (Programmer)

10 Jul 12 16:58

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 (TechnicalUser)

10 Jul 12 19:45

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 (MIS)

11 Jul 12 11:10

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 (Programmer)

12 Jul 12 19:28

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
www.crystalkiwi.com/nlog.htm

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 4 Other topics