Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: how to "has at least a certain result" Post Reply Post New Topic
Author Message
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Topic: how to "has at least a certain result"
    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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.