Skip to Content
author's profile photo Former Member
Former Member

Update Properties for tables with Alias name in Crystal Report 9


I am having reports created with ODBC[with SQL Authentication] which is having 2 tables used for Self Join. So both tables are having alias name for it.

Now, I have updated the ODBC(Change in Database name and Changed SQL Authentication to Windows Authentication). I have tried to update the Data source and Table properties with the new ODBC Settings through "Set Datasource Location". There I am not able to update the table since it is having alias name.

I want to update the data source properties for all the tables without affecting the query.

Please help to resolve the issue.

Thanks in Advance.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 02, 2014 at 12:46 PM

    Hi Ranjith,

    The recommended way to set the datasource is to 'update' each table one by one instead of simply updating the datasource name.

    What happens when you try to update the table that has the alias name?


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.