Crystal Reports select first row

Message


     Not exactly. Part of this is a bit of a language issue with the word displayed. Often people refer to displayed as meaning "not hidden". There is a big difference because rows or items that you hide (suppress) are still in the report and are still included in SUms, counts, averages, etc. ,they are just not displayed. With the group selection the data is more akin to removed from the the report and no longer end up in any calculations (sums, counts etc.). To further confuse on this if you are grouping and do the selection on that a group minimum you will still see the removed groups in the group tree.
That being said. Say you 3 tables all with one row for the field you want to join on. Say you do a minimum() on table 1 to get it to one row out of all of the rows. Now you take table 1 and join it to table 2 and you still get one row. Now you add table 3 and join table 1 to it. now you have 2 rows.
if you had had joined table 1 to table 2 and table 2 to table 3 you would have 1 row of data.
Is this making sense?