Crystal Reports How to keep fields on report when changing SP?

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: How to keep fields on report when changing SP?
	<< Prev Page of 3

Author	Message
lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 22 Jun 2009 at 6:28am
	I would have suggested to change the database/location in the DSN. Crystal doesn't care where the data comes from, just that it looks like the 'report'. As long as the data can be retrieved from the same tables/stored proc/view Crystal will be fine. for years, that is how I would develop reports.
	IP Logged

hill.kenneth.b Newbie Joined: 06 Jul 2009 Location: United States Online Status: Offline Posts: 5	Posted: 06 Jul 2009 at 5:52pm
	*Originally posted by Gremlin1708* Hi There... I came across this post for the same reason you posted it :-) Well after a long struggle i think i mite have the answer for us. If you have a "Dev" server and a "Active" server and you want to post your reports to the Server that's got the live data then to change the ODBC you : 1. right click on the Table Name / Sp in the Field Explorer 2. Select Set Datasource Location from the Pop up Menu. 3. Expand from Report >> ODBC Conn >> Properties 4. There you will see DSN 4.1. Right Click and select "Edit" 4.2. Rename the DSN and then select the ODBC that your active server is on. This is what i did and it worked 100% it kept my Fields on the correct place and it showed me the "live" data. Hope this is of help for you. Does this work in CrystalReports9,X or XI? I have no problem with changing data source locations for stored-procedures, but tables and views don't seem to work for me.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 07 Jul 2009 at 6:18am
	It should. The basics of how Crystal connects, I don't think has changed for a long time. If you can change the source location for a stored proc, changing tables should be the same. I change odbc connections but first updating the odbc connection for the report, and then for each table inside of the connection(for some reason, updating the connection doesn't change the tables...makes no sense to me). But I believe that you already tried that, so I don't know what else to add. Sorry.
	IP Logged

Gremlin1708 Newbie Joined: 22 Jun 2009 Location: South Africa Online Status: Offline Posts: 8	Posted: 07 Jul 2009 at 6:24am
	*Originally posted by hill.kenneth.b* *Originally posted by Gremlin1708* Hi There... I came across this post for the same reason you posted it :-) Well after a long struggle i think i mite have the answer for us. If you have a "Dev" server and a "Active" server and you want to post your reports to the Server that's got the live data then to change the ODBC you : 1. right click on the Table Name / Sp in the Field Explorer 2. Select Set Datasource Location from the Pop up Menu. 3. Expand from Report >> ODBC Conn >> Properties 4. There you will see DSN 4.1. Right Click and select "Edit" 4.2. Rename the DSN and then select the ODBC that your active server is on. This is what i did and it worked 100% it kept my Fields on the correct place and it showed me the "live" data. Hope this is of help for you. Does this work in CrystalReports9,X or XI? I have no problem with changing data source locations for stored-procedures, but tables and views don't seem to work for me. This post was posted when i was using Cyrstal Reports XI R2.
	IP Logged

hill.kenneth.b Newbie Joined: 06 Jul 2009 Location: United States Online Status: Offline Posts: 5	Posted: 07 Jul 2009 at 8:32am
	I'm able to do this, but now when I try running the report through the browser I get prompted to enter a database login name and pw; I don't get this prompt when viewing the report in the CR preview.
	IP Logged

Gremlin1708 Newbie Joined: 22 Jun 2009 Location: South Africa Online Status: Offline Posts: 8	Posted: 07 Jul 2009 at 10:41pm
	This has got something to do with the user rights on the Server and aslo then i installed the .Net framework 3.5 and then the IT Dept also did some changes. I will call them later today and then find out what exactly they did and how they fixed the problem.
	IP Logged

ch_tech Newbie Joined: 11 Nov 2010 Location: Switzerland Online Status: Offline Posts: 1	Posted: 11 Nov 2010 at 4:02am
	Thank you so much for your post, it pointed in the right direction!!
	IP Logged

<< Prev Page of 3

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