I want to show First In and Last out of the employee per day(working hour 8:00 to 5:00),in addition to this

i want last out and Last in  for the lunch break(in between 12:45 & 2:15) for that day.Other events should be suppressed in the report.

I'm facing a problem to design the report.Pls help me...

 

 

 

The Event table looks like this

EmpID     DEVID     EVENTTIME
25              1             2011-04-28 08:42:17.000
25              2            2011-04-28 10:42:18.000
25              1            2011-04-28 11:42:18.000
26               2           2011-04-28  12:50:00:000
26               1           2011-04-28  14:10:00:000
26                2          2011-04-28   16:10:00:000
DEVID=1 for IN Transaction and DEVID=2 for OutTransaction
Requirement:-
I have to group the report by Department,employee and Date.
I have to show the following information in the report.
1.FirstIn And LastOut  for the employee per day( In between 08:00 AM and 05:PM)
2.Total Time Duration(Lastout-FirstIn)
3.Lunch break(Last out and Last in inbetween 12:15 Pm and 2:15 Pm)
4.Total outside=Lunch break ,he has taken
5.Total inside office= Total time Duration-Total outside.

I achieved the FirstIn and Lastout by ,showing the first in onthe groupheader of  Date and Last out on the group footer.
and the detail section is suppressed.
The problem is that i cannot findout the lunch break time.The max and min functions is not applicable because the DEVID is related to
another Table READER

READER ID   READER DESC
1                     Main entry
2                     Main Exit

Anybody knows any solution to design this report

and I have done a formula for finding out the lunchout.and here it is:

Local DateTimeVar Time1 :={EVENTS.EVENT_TIME_UTC};

stringvar y := Cstr(datepart("YYYY",Time1,0));
 
Numbervar y1 := Tonumber(y);

stringvar m := Cstr(datepart("M",Time1,0));

Numbervar m1 := Tonumber(m);

stringvar d := Cstr(datepart("D",Time1,0));

Numbervar d1 := Tonumber(d);

DateTimevar PlannedTime1 := DateTime (y1,m1 ,d1 ,12 ,45 ,00 );

DateTimevar PlannedTime2 := DateTime (y1,m1 ,d1 ,14 ,15 ,00 );
if ( EVENTS.EVENT_TIME_UTC>= PlannedTime1 AND ({EVENTS.EVENT_TIME_UTC}<=PlannedTime2)and ({READER.TIMEATT}=2)
then
DateTimeVar out :=DateAdd("h",3,{EVENTS.EVENT_TIME_UTC});

but it is not doing the job,what i required.