Hello
Could you please help me with a report I've been asked to write. I have never used Crystal Reports before. I've read the manual but don't quite understand how to create 2 fields I need in the report.
1. I need a column that has the difference between swipe in and out times.
2. I need to show a warning message if someone swiped in but didn't swipe out or the opposite, they swiped out twice.
The data in will come in like this:
Access Granted In 7/25/2008 8:00
Access Granted Out 7/25/2008 10:00
Access Granted In 7/25/2008 12:00
Access Granted Out 7/25/2008 16:14
I would like the report to to show:
Transaction Scan Time Time/Diff Warning
IN 8:00
OUT 10:00 2:00
IN 12:00
OUT 16:14 4:14
IN 8:00
IN 9:00 Did not swipe out
OUT 10:00 1:00
OUT 11:00 Did not swipe out
Thank You for your time
IP Logged
