Linking table bug?

[Bennie47250]

Using Crystal version 7.0

I have three tables and I’m linking them together as shown below.

I knew as I was linking the tables I should only have one record returned, but when it ran two were returned. I was able to get the one correct record to return by including the linked field (Lead Source from table C) on the report.

Is this a bug in Crystal?

My linking is:
Table A to Table B
CustID = CustID
LastDate = LastContactDate

Table B to Table C
CustID =CustID
Lead_Source = Lead_Source

The report originally had these fields in the detail section Table A CustID, LastDate and Table B Lead_Source.

When I added Table C Lead_Source to the detail section I received the correct # of records

I checked the SQL query before and after adding Table C Lead_Source and it is different.

Never experienced this before.

Thanks
Bennie

 

[synapsevampire]

Table C probably wasn't being used at all, so anything different wasn't being reflected. You added a table, but since you didn't use it, CR might have politely ignored it as a meaningless join.

-k

 

[Bennie47250]

Should CR been so polite? I sure hate it when software tries to be helpful. Sure seems odd that the SQL changes.

 

[lyanch]

CR always only includes the joins and tables necessary to include all the fields displayed/used in selection/used in formulas/SQL Expressions that are actually used somewhere in the report.

You can add 10 tables in the SQL designer and display one field from one table on the report.. go check the SQL crystal created.. the only table in the SQL will be the one single table that you displayed a field for.

Lisa