Print Page | Close Window

Change data source

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12204
Printed Date: 09 Apr 2025 at 12:05am


Topic: Change data source
Posted By: aspfun
Subject: Change data source
Date Posted: 01 Feb 2011 at 10:52am
There 5 crystal reports which have the same fields.
Each of them is using different store procedure as datasource as sp1, sp2...sp5
I have done first report rp1. I copied rp1 as rp2.
How to change rp2 datasource from sp1 to sp2?


Replies:
Posted By: lockwelle
Date Posted: 02 Feb 2011 at 3:31am
if all the fields are the same...
 
go to database, set database location, select the desired stored proc in the bottom window, select the 'old'/orig stored proc in the top, click update.  close.  Verify the database and you should be done.  If there is a difference in fields that are being displayed on the report, CR will prompt with a mapping screen.
 
I'm not positive that will work for changing SPs, but I suspect it will.  It is how I update databases when I need to change them.

Posted By: aspfun
Date Posted: 03 Feb 2011 at 5:26am
I did it the same way but sp1 never change to sp2 even though I click update button.

Posted By: lockwelle
Date Posted: 04 Feb 2011 at 3:00am
It's been a really long time since I have done this, but I would say to check the properties and see what they say.  I would say check the fields, but if the fields are the same, you won't see any difference.
 
HTH


Print Page | Close Window