Print Page | Close Window

Updating db tables

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=467
Printed Date: 29 Apr 2024 at 7:35am


Topic: Updating db tables
Posted By: aekelund
Subject: Updating db tables
Date Posted: 05 Apr 2007 at 8:37am
Hello,
 
I'm having some trouble updating db tables in crystal report designer 11.  Where do I go in crystal to update/view which db tables are being used in a specific report?
 
Thanks,
Andrew


-------------
Andrew


Replies:
Posted By: BrianBischof
Date Posted: 05 Apr 2007 at 11:00am
To see which databases are being used in a report, goto the menu options Database | Database Expert.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: aekelund
Date Posted: 05 Apr 2007 at 11:34am

Thanks,  now I relize I need to adjust the SQL statement in the report how do I go about doing that?



-------------
Andrew

Posted By: BrianBischof
Date Posted: 05 Apr 2007 at 11:36am
I don't know what you are doing. Are you linking tables with the database expert or do you want to enter a custom SQL string? If you want to enter a custom SQL string, then you have to click the Add Command node listed under your datasource name in the Database Expert dialog box.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: aekelund
Date Posted: 05 Apr 2007 at 1:35pm
Im looking at the "show sql query " under the database tab.  The query that is being shown needs to adjusted becuase of some table name changes. Can I edit this SQL statement or do I need to add a whole new SQL statement?

-------------
Andrew

Posted By: BrianBischof
Date Posted: 05 Apr 2007 at 4:40pm
That query can't be changed. It is a result of the tables you picked in the Database Expert. If you want to change table names then you need to choose the menu items Database | Set Database Location. Then you can click the old table and replace it with the new table. Afterwards you'll be able to look at your SQL Query and see that it is different.


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: aekelund
Date Posted: 11 Apr 2007 at 10:22am
Thanks for the help all your suggestions were great.


Print Page | Close Window