I work in an alarm monitoring centre, and we have used Crystal Reports for about 2 years now. I've mostly made simple reports, but suddenly everyone in my company has found this to be a great tool, and I get more and more requests for more advanced reports.

 

Right now I am working on a report where I need to extract the earliest date/time for an eventcode in what we call a signal element, which is a unique number related to all activity regarding a specific incident.

This eventcode can occur several times in a signal element.

 

 

s_elem               Eventcode              date

1953484            10                           2007-11-27:08:00:00

1953484            23                           2007-11-27:08:13:05

1953484            10                           2007-11-27:08:15:43

1953484            10                           2007-11-28:08:23:16

 

In this case I need to pick out the date 2007-11-27:08:00:00 to use in another formula.

 

I have been twisting my brains out for 2 days now, but can't come up with a solution. Can anyone help, pls? :)

This works fine! Guess I was thinking too complicated.

 

Thanks for your help.

 

Kjetil