Hello,
For brevity, I will describe the linkage between only 3 tables using
Crystal Reports.
A is linked to B through a left outer join.
B is linked to C through a regular(=) join. (can only have 1 left
outer join in Crystal)

The report works fine until I mention table "C" while defining a
formula.  Then I only retrieve 10 records instead of 238 that the left
outer should give.

I want the date from 'A' if there is no record in C.
Otherwise I want the date from 'C'. I cannot link A and C directly.

IF (IsNull "a key field in table 'B'")
     THEN
"date from table A"
ELSE "date from table C"   ****THE ADDITION OF THIS LINE REDUCES THE
RETURNED RECORD COUNT TO 10

I'd appreciate any help with this.