Print Page | Close Window

Linked Tables - Basic question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2770
Printed Date: 04 May 2024 at 4:32pm


Topic: Linked Tables - Basic question
Posted By: rboursaw
Subject: Linked Tables - Basic question
Date Posted: 31 Mar 2008 at 7:10pm
When creating a new report which utilizes multiple tables and you arrive at the part of the wizard which shows the link relationships....  What does this apply to? 
 
Meaning.....
 
Let's say the tables in question have no key constraints setup.  It appears that Crystal is taking a stab (right or wrong) as to what items should be linked between the tables.  Can I modify the relationships?  If so, does this change the actual DB or is it just self contained within the report that I am creating?
 
Basically, I want to know if changing information on this screen actually modifies the DB or not.
 
Thank you all for your assistance.


Replies:
Posted By: BrianBischof
Date Posted: 31 Mar 2008 at 8:06pm
Yes, Crystal is just taking its best guess on what the links are. It looks for things like primary keys, indexed fields, matching the names up, etc. It is wrong often and you can delete the links and make your own.  It only effects the SQL query that CR uses to pull data from the database. It has no impact on the database.

I have tons of tips and tricks for optimizing database performance in my Encyclopedia book. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online.

-------------
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>


Print Page | Close Window