Grand total for each person on first line of name but not repeat per line of detail

[wanzek1]

I would like to come up with something in crystal that looks like the following:

Department Emp# Name Job Class Hours Total
Corporate 5906 Amanda Anderson PM 8 70
Corporate 5906 Amanda Anderson 711 PM 40
Corporate 5906 Amanda Anderson 811 PM 14
Corporate 5906 Amanda Anderson 814 PM 8
IPOG 15399 Jim Bob FLD 8 88
IPOG 15399 Jim Bob 814 FLD 78


Everything is extremely easy to do except I can't figure out how to get a total (like in the very right hand column) that totals all the hours for that employee and puts it only once on the top line. I can get the total easily on a separate line.

Any ideas? I am using version 2011.

Thanks

 

[IanWaterman]

Move all your details in group header which holds your total and suppress details.

Ian