Trick needed - !!!

[BilboB]

I need to select records from a right hand file joined where the join is left outer.... Is this possible?

i.e. I need to see all my records in my left table, unless the right table has a value of 99 in one field "Status".

Am I barking?

BilboB

 

[synapsevampire]

Sounds like a standard LO join to me.

In the Report->Edit Selection Formula->Record place:

not({righttable.value} = 99)

If this doen't resolve, use technical information instead of descriptions:

Crystal version
Database/connectivity/premission to build database objects
Example data
Expected output

-k