Crystal Reports HOW TO: record has at least a history of...

Message

     Hi all,

In the Select Expert, how do I add a certain criterium that sound like:
"Records should have at least a history where field RESULT=DO_LATER, but may have other results (later on) as well"

I'll Explain with examples. Here's a single record:

TIME        MACHINEID  RESULT
5-may-2008  mach1      DO_LATER
So far so good. Here's another example:

TIME        MACHINEID  RESULT
5-may-2008  mach1      DO_LATER
6-may-2008  mach1      ALL_DONE
There it is. This "mach1" has a history of "DO_LATER" and therefore I'd like to export all results of "mach1", whatever it did after "DO_LATER".

Here's another example:

TIME        MACHINEID  RESULT
5-may-2008  mach1      DO_LATER
6-may-2008  mach1      ALL_DONE
6-may-2008  mach2      ALL_DONE
So "mach1" we are interested in, but not "mach2". It has no history of "DO_LATER".
So we'd like to observe whether machines that will process tasks later actually do that. Perhaps they don't and report an error or even another "DO_LATER" event.

I'd be jolly happy if anyone could help me out.