Changing of Table Names IN Crystal Reports

Posted on 2005-04-14
Last Modified: 2010-12-07
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


Question by:rikleo2001

    Author Comment


    I have Managed to Change the Database Table Names, ACCORDING TO THIS ARTICALE.

    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?
    LVL 100

    Expert Comment

    There is a third party tool to help with this process.  I am not sure if it does anything different than what you got.

    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.

    LVL 10

    Expert Comment

    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.


    LVL 26

    Accepted Solution


    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.


    Author Comment

    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.

    LVL 26

    Expert Comment

    by:Kurt Reinhardt
    Glad I could help:)


    Expert Comment

    rhinok is great. You solved my problem as well. Thanks very much for your solution.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now