Print Page | Close Window

how to "has at least a certain result"

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3404
Printed Date: 06 May 2024 at 4:14am


Topic: how to "has at least a certain result"
Posted By: Valmont
Subject: how to "has at least a certain result"
Date Posted: 11 Jun 2008 at 8:04am
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.


Print Page | Close Window