Crystal Reports Change data source

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: Change data source

Author	Message
aspfun Newbie Joined: 17 Jun 2010 Online Status: Offline Posts: 27	Topic: Change data source 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?
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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.
	IP Logged

aspfun Newbie Joined: 17 Jun 2010 Online Status: Offline Posts: 27	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.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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
	IP Logged

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.039 seconds.