Hi,
I am trying to get the minimum date, where a condition is equal an identity number.
I know how to do this SQL, but I'm getting slightly lost in Crystal.
Minimum (<date/Time>, <Case ID>)
where Condition = 175
I hope this is makes sense.
TJ
I am already doing the suggestion by Madawc, but thanks none the less.
I have had a brief look at the, report->edit selection formula->record, or report->edit selection formula->group this seems like the place to start.
I'll have ago tomorrow and will report back, thanks for the info.
Can you help?
BACKGROUND
I'm trying to display a list of open cases per a person in per a queue so I have the following grouping.
Queue. => Person. => Case I.d
I only want open cases to show. Within each grouping I have information about group, e.g. In the queue I have details of which queue...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.