A.O.A,
I have a report that shows Overtime of an employee of a particular month.
 I want to calculate the total number of overtime in footer
This is how i'm calculating overtime
- "tout" is EmployeeLeavingtime
- "otLimint" is the Timelimit (like if ShiftEndTime is 6:00PM then overtime will be 
 calculated if tout is > 6:30)
- shiftendTime is (6:00PM) 
 
 - string timeOut = r["TimeOut"].ToString();
 Time tOUT = new Time(timeOut);
 Time OtLimit = new Time(18, 30, 00);
 
 if (tOUT > OtLimit)
 {
 DateTime ShiftendTime = Convert.ToDateTime(r["ShiftEndTime"].ToString());
 DateTime Out = Convert.ToDateTime(r["TimeOut"].ToString());
 TimeSpan span = Out.Subtract(ShiftendTime);
 r["OTHrs"] = span.ToString().Replace("-","");
 }
 
im using
Sum(Fields!TotalLH.Value) in Report footer expression
 but this is not showing Total at runtime
 
No comments:
Post a Comment