Print Page | Close Window

Change a data source without remapping fields?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5834
Printed Date: 02 May 2024 at 9:15am


Topic: Change a data source without remapping fields?
Posted By: birchw
Subject: Change a data source without remapping fields?
Date Posted: 20 Mar 2009 at 4:27am
Hi, I have a report in Crystal 10 for which I need to change the data source.  The report currently points to a stored procedure called "rpt_1279_Annual_Statements", however this SP does not follow our standard naming convention.  The SP should be called "rpt11696_1279_Annual_Statements_Admin".  I have created a new SP with the correct SP name - this is exactly the same SP, just a different name, however when I try to change the data source, all of the fields on the report are being dropped.  Is there anything I can do about this, as I would rather not have to re-map every field manually!  Thanks.


Replies:
Posted By: DBlank
Date Posted: 22 Mar 2009 at 5:54pm
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5229 - http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5229

Posted By: birchw
Date Posted: 23 Mar 2009 at 2:54am
Thanks DBlank. 

Posted By: karenros
Date Posted: 11 Jun 2009 at 1:48pm
Dblank
 
I have created a new sproc by adding some fields to the new sproc and  i followed your instructions to update the data source but in my current connection i see the new sproc name but my database fields havent updated....
 
What should i do in order to update them
 
Thanks,
Karen

Posted By: DBlank
Date Posted: 12 Jun 2009 at 6:58am
Try selecting Database >Verify Database.


Print Page | Close Window