Print Page | Close Window

Problem link database tables

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=706
Printed Date: 04 May 2025 at 6:08pm


Topic: Problem link database tables
Posted By: ChrisJ517
Subject: Problem link database tables
Date Posted: 21 May 2007 at 7:09am
I'm trying to link 3 database tables.  They all have at least one common field (ACCOUNTNO).  I have linked them using this field.  However, everytime I design a report and try to use fields from different tables, the report doesn't show any data.
 
For example, (assume table names are table1, table2 and table3)if I create a report using all fields from one table, it works fine (of course).  But if use the accountno field from table2 in place of the accountno field from table 1, all the data goes away, even though the two accountno fields have the same data in both tables.  Any thoughts?


Replies:
Posted By: jayhawk
Date Posted: 22 May 2007 at 10:13am

Somehow when it's joining the two tables, it's not finding an equal link. Check out how it is linking table1 and table2. Sometimes it auto-picks all of the fields that it finds between the two tables that are named the same and it will try to make a join based on all of the fields. If the primary join between the tables is the accountno field, make sure that's the only link in there(delete any other ones). Or, if that is the only join, check and make sure that the accountno field really is exactly the same in the two tables(sometimes one could have a space character at the beginning or end of the string and that would cause the join to fail).



Print Page | Close Window