We help IT Professionals succeed at work.

crystal reports - Total Time in Group Footer

kelsanit
kelsanit asked
on
Have report (attaached) that has two groups - Driver & Route ID.  In the footer of the routeID group I show the total time for the Route. I now need to total that time up and show in the Driver Footer but cannot figure out how to make this work.

Example:
Driver: AP  
Route:  CJ
Total Time CJ Route = 2:00
Route: MP
Total Time MP Route = 8:00

Driver AP:  Total Route Time: 10:00
test-route-sub-for-team-hours.rpt
Comment
Watch Question

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try this version.

Basic method is to add up the minutes for the driver in the formula where you display the route time then display it in the driver footer.

mlmcc
test-route-sub-for-team-hours.rpt