• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6131
  • Last Modified:

Changing of Table Names IN Crystal Reports

Hello Experts,

I can only solve this issue with only your help.

I have 98 Crystal reports developed in CR9. Working Fine.

Due to some changes in database, I am fully structurizing the databse Table Names.
Now every table name has been changed now, except the database name. All fields in the tables are same as earlier.
But the reports got the old names till yet.

Is there an easy way to change the Table names from the actual reports?

Thanks in Advance

Rik






0
rikleo2001
Asked:
rikleo2001
1 Solution
 
rikleo2001Author Commented:
Hi,

I have Managed to Change the Database Table Names, ACCORDING TO THIS ARTICALE.
http://support.businessobjects.com/library/kbase/articles/c2001784.asp

but my table names are still appearing with old table names, but when I looked into the propertise, it says that tablename = new_tablename

But I want to change the appearing name of the tables as well.

Any thoughts to get around this issue?
0
 
mlmccCommented:
There is a third party tool to help with this process.  I am not sure if it does anything different than what you got.

http://www.softwareforces.com/Product/ri/pro/2/ri_index.htm


I found the only way around your issue was to "rebuild" the report using the new tables.  Not a pleasant task.  The rptInspector tool wasn't available when I did that.

mlmcc
0
 
ebolekCommented:
i dont think you can do that. when you set the datasource of a table it overrides the qualified name but still holds the old table name.

Regards
Emre

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
rikleo2001,

What you're talking about doing is changing the alias of the table.  When you first created the report, Crystal created an alias of the table name based on the original table name.  Since you've changed the table via Set Location, you may want to rename the alias (you don't have to, but it makes maintenance easier).

All you need to do, within Crystal 9, is navigate to Database|Database Expert.  Select a table in the right-hand pane so that it is highlighted and push the F2 button.  This will allow you to rename the alias (the instructions for doing  so are actually in the Database Expert dialogue box).

Of course, this process may be fairly tedious with as many reports as you have due to it being a manual process.  Report Inspector will let you Set Location and Verify Database for several reports at once, but I don't think it will let you change Aliases.  I haven't had a copy installed for awhile and I can't find this functionality listed on the website, so I don't know for sure.

~Kurt
1
 
rikleo2001Author Commented:
You know what ~Kurt.
You are really too much.

I can't say how should I thank you for that. But it Worksssssssssssssssssssssssssssss.

Here you go extra Bonus Points for you, Thanks again.

Thanks everyone who supported me.
I really appriciate all.

Rik
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Glad I could help:)

~Kurt
0
 
Elaine_ShiCommented:
rhinok is great. You solved my problem as well. Thanks very much for your solution.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now