Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Changing Data Source Post Reply Post New Topic
<< Prev Page  of 2
Author Message
XavierVP
Newbie
Newbie
Avatar

Joined: 10 Jun 2010
Location: United States
Online Status: Offline
Posts: 1
Quote XavierVP Replybullet Posted: 08 Jul 2010 at 4:27am
Hi
I have many reports that I create and test in my development website before publishig to my users, is there a way to change the dataset the report points to in bulk, having to go one at a time is time consuming.
 
Also does anyone know why when you change a dataset the properties do indicate it is pointing to the correct one but just in plain view it looks like it is pointing towards the old one, how can this be refreshed.
 
This is also a time consuming task to have to check the poroperties to make sure the report is pointing to the correct dataset.
 
Thanks
Xavier
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 08 Jul 2010 at 7:04am
I believe there is a third party software that will do this.  I do not remember the name of the product.
IP IP Logged
skumarnvcghd
Newbie
Newbie


Joined: 15 Nov 2010
Location: India
Online Status: Offline
Posts: 1
Quote skumarnvcghd Replybullet Posted: 15 Nov 2010 at 10:41pm
Go to Reports -> Report Expert -> Right Click selected sp and rename. Then verify the database.
IP IP Logged
DataAngel99
Newbie
Newbie


Joined: 18 May 2011
Online Status: Offline
Posts: 2
Quote DataAngel99 Replybullet Posted: 18 May 2011 at 4:59am
You can actually change the name of the datasource to whatever you want in the Database Expert.  If you right click on the datasource in the right-hand side of the Database Expert, there will be a "rename" option that pops up.  I was able to rename it so it reflected the source change.
 
I too was wondering why my table didn't change to my view.  I found your post which helped me figure out that in fact, it did change, so thanks!
IP IP Logged
fhschmid
Newbie
Newbie
Avatar

Joined: 01 Feb 2011
Location: United States
Online Status: Offline
Posts: 2
Quote fhschmid Replybullet Posted: 09 Jun 2011 at 8:38am
Yes, you can change the name by going into the Database Expert in the drop down menu under Database. Right click on the name of the "Table" in the Selected Tables: section and choose the Rename option.
IP IP Logged
vandinem
Newbie
Newbie


Joined: 26 Jun 2012
Online Status: Offline
Posts: 2
Quote vandinem Replybullet Posted: 26 Jun 2012 at 10:54am
Don't ask me why they require this, but if you change the stored procedure as you describe:

- Go to the Report Explorer

- Right-click on the (old) procedure name [this is usuall the top element of the tree for my reports]

- Select the 'Summary Info' menu choice

- Update the text for the 'Title' field to reflect the actual stored procedure name, and click 'OK'
IP IP Logged
<< Prev Page  of 2
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.