I want to display first in last out of employee per day in crystal report.
The problem is that ,the IN and OUT entry is identified by the reader,
ie,
READER=1 for IN entry
REDER=2 for the Out entry
I'm using this formulas for the first in and last out
DateTimeVar Time1 :=minimum({EVENTS.EVENT_TIME_UTC},{@EDATE});
DateTimeVar Time1 :=maximum({EVENTS.EVENT_TIME_UTC},{@EDATE});
the problem is that ,there is no way to identify,the value is correct for
Entry and exit.
some times,the maximum({EVENTS.EVENT_TIME_UTC},{@EDATE}) is occured in the READER=1
Is there any way to find, the minimum time for REDER=1
and
Maximum Time for READER =2
IP Logged
