Hi everyone,
This is my first post! I am creating crystal report to display attendance record of employees. I am stuck now getting the grand total of (Dailyw
WorkedHrs). Need some help... My desired report output is as follows. I am able to get the fields "IN1", "IN2" and "TotalHrs" on my report. But need help on getting the "TOTALWORKEDHRS" for each employee which is the sum of "TotalHrs".
Any help!!
Cheers
irfi
EmpID 001----------EmpName John Zaq
In1----------Out1----------TotalHrs
09:00-------15:30-------06:30
09:30-------16:00-------07:30
09:15-------17:15-------08:00
TOTALWORKEDHRS 22:00
--------------------------------------------
EmpID 002----------EmpName Sara Bell
In1----------Out1----------TotalHrs
08:00-------15:30-------07:30
08:30-------16:00-------08:30
08:15-------17:15-------09:00
TOTALWORKEDHRS 25:00