Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Changing SQL Stored Procedure? Post Reply Post New Topic
Author Message
Chrispy1
Newbie
Newbie
Avatar

Joined: 29 Nov 2006
Location: Canada
Online Status: Offline
Posts: 8
Quote Chrispy1 Replybullet Topic: Changing SQL Stored Procedure?
    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.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.