Links not reflected in Database sql query or records returned?

[Jacque]

I have a report using 6 tables which are linked to limit the information show, the only fields used in the report are from the last table. When I look in the sql query, it only reflects the table which the fields used in the report.

The first table has only one record, the name of the machine, the second table lists the names of all machines available. I have an equijoin on table1.mymachinename to table2.machinename (fields are named slightly different but the datatype and size are the same). I need to have the second table since it provides the link to the next table.

Yet, when I run the report, it doesn't take into consideration with equijoins between the tables which should limit the data to just 'my machine data'. I tried refreshing the sql query, no luck.

One way around this was to put the following in the group selection. table1.mymachinename = table2.machinename

The other way was just to place a field from table1 in the report and surpress it.

Both of these made the sql query reflect the linking done and limits the data to just 'my machine data'. I've got the report working correctly but am curious if anyone else experienced this?

 

[balves]

This is a "feature" of Crystal. If you join to a table and then do not use any fields in the table, it drops that table out of the SQL query.


This is a feature I've never understood. It's almost as if they don't understand relational databases at Crystal.