Print Page | Close Window

Changing SQL Stored Procedure?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=94
Printed Date: 17 May 2024 at 9:35pm


Topic: Changing SQL Stored Procedure?
Posted By: Chrispy1
Subject: Changing SQL Stored Procedure?
Date Posted: 07 Jan 2007 at 3:57am
HELP!!!  I'm working on a pre-existing report that I've rewritten the entire stored procedure in the back end.  I've had to change quite a bit, especially the naming convention used, so it's not a simle matter of naming the new procedure the same thing as the old one - so my question is how do i change the Query the Crystal report is pointing to without rebuilding the entire report?  The report itself is extremely complicated, and would require me at least 15 - 20 hours to rebuild.
Any ideas would be greatly appreciated.
Thanks for your time....
Chrispy1


-------------
There are 10 type of people in the world - Those that understand binary and those that don't.


Replies:
Posted By: BrianBischof
Date Posted: 07 Jan 2007 at 10:35pm
Have you done Set Database Location? You can point it to a new SP and then remap the fields when there are conflicts. This makes it easy to swap out one data source with another.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window