| Author |
Message |
rptxyz
Newbie
Joined: 24 Nov 2007
Online Status: Offline
Posts: 27
|
  
Topic: report
Posted: 25 Dec 2007 at 4:52pm |
|
Got two stored procedures that have slight difference with all the fields being the same. How to change my report to point to the other without redo most of the work?. Like to keep everything intact but just change the name of the stored procedure used. usually in this process all fields get removed and has to redo most work.Crystal Report 9.
|
 IP Logged |
|
|
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 25 Dec 2007 at 6:27pm |
|
Choose the menu option Set Datasource and select the new stored procedure. Then click the replace to swap them out. This way the report doesn't have to change at all.
|
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 Logged |
|
rptxyz
Newbie
Joined: 24 Nov 2007
Online Status: Offline
Posts: 27
|
Posted: 25 Dec 2007 at 7:14pm |
|
in "set datasource location", in the "current source location" i chose the stored procedure1 and in "replace with" window i chose the stored procedure2 and clicked on Update. that in the "current datasource location" window only changed the Table Name under the properties of the stored procedure1 to the stored procedure2. It did not replace the stored procedure1 naming itself. so, only its properties changed. Also, it failed to save.
|
| IP Logged |
|
Lugh
Senior Member
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
|
Posted: 26 Dec 2007 at 7:15am |
|
Well, in an odd quirk, Crystal will not actually change the way it refers to the datasource internally. So, all of your formulas will still look like they are pointing to {StoredProc1.MyData}. However, it really is using the other procedure to actually retrieve the data. It's confusing, but that's the way it works.
What do you mean by "it failed to save"?
|
| IP Logged |
|
rptxyz
Newbie
Joined: 24 Nov 2007
Online Status: Offline
Posts: 27
|
Posted: 26 Dec 2007 at 8:05am |
|
when i clicked on save button , it tried to save. But, gave "failed to save" messagebox.
|
| IP Logged |
|
|
|
