Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Change view name Post Reply Post New Topic
Author Message
bfasula
Newbie
Newbie


Joined: 22 May 2008
Online Status: Offline
Posts: 4
Quote bfasula Replybullet Topic: Change view name
    Posted: 22 May 2008 at 7:49am
I have several reports that use a particular DB view. I would like to rename the view. Is there a way to have crystal switch to use the new view name?
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 23 May 2008 at 4:40am
Yes, but it's a tad tedious.

If you go into Database Expert on each report, you can go into Set Datasource Location.  You will then be able to point the report to the new view.

Here's the tricky thing, though.  All of the elements of the report will still look like they are pointing at the old view.  When you look in the Field Explorer, the old view's name is there.  When you reference the fields in formulas, you use the old view name.  It's like Crystal kept the old name as an alias.  Presumably, this is to keep references in formulas and the like from breaking.  Why Crystal thinks this is easier than doing a global find and replace is beyond me.


IP IP Logged
Tim Wise
Newbie
Newbie
Avatar

Joined: 29 Apr 2008
Location: United States
Online Status: Offline
Posts: 31
Quote Tim Wise Replybullet Posted: 23 May 2008 at 9:37am
> All of the elements of the report will still look like they are pointing at the old view. 
 
In the Database Expert, you can r-click on the 'view name' in the right pane and change it to something else.
 
What you see as the 'view name' is an arbitrary name. It was initilized to the name of the view you originally choose, but you can rename it to anything in the Database Expert.
 
In Set Datasource Location, you can see the real name of the underlying view/table. Expand the datasource tree you see in the top pane and you will see the underlying Table name. That's the real name of the view. If you use Set Datasource Location to point to a different view, the Table name will  change, but not the 'view name.'
 
There was just a discussion of this here.
 
Make sense?
 
--
Tim
IP IP Logged
bfasula
Newbie
Newbie


Joined: 22 May 2008
Online Status: Offline
Posts: 4
Quote bfasula Replybullet Posted: 17 Sep 2008 at 9:51am
Thanks it worked great.
IP IP Logged
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.031 seconds.