Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Calculate total time on my crystal report Post Reply Post New Topic
Author Message
irfi
Newbie
Newbie


Joined: 16 Mar 2010
Location: United States
Online Status: Offline
Posts: 1
Quote irfi Replybullet Topic: Calculate total time on my crystal report
    Posted: 16 Mar 2010 at 9:57am

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
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 16 Mar 2010 at 11:44am

What data type is TotalHrs?  How did you calculate TotalHrs? 

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.023 seconds.