Hi everyone,
I am creating a report in vb.net using crystal reports and need help on finding sum of dailyworkhrs in my crystal report. I have a field which calculates dailyworkhrs and now i would like to find the total of it.
What is the best way to do the grand total is it to do it during the report runtime by using the formulas or can do it on the form which is the best way would appreciate any help on this!! How to sum up the time in format HH:MM
Cheers
irfi
Desired Crystal Reprot Output
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 ' HOW CAN I ACHIEVE THIS ON THE REPORT
--------------------------------------------
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 ' HOW CAN I ACHIEVE THIS ON THE REPORT
I am creating a report in vb.net using crystal reports and need help on finding sum of dailyworkhrs in my crystal report. I have a field which calculates dailyworkhrs and now i would like to find the total of it.
What is the best way to do the grand total is it to do it during the report runtime by using the formulas or can do it on the form which is the best way would appreciate any help on this!! How to sum up the time in format HH:MM
Cheers
irfi
Desired Crystal Reprot Output
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 ' HOW CAN I ACHIEVE THIS ON THE REPORT
--------------------------------------------
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 ' HOW CAN I ACHIEVE THIS ON THE REPORT