Regularhours overtime workhourdate
0 0 7/20/2014
8 2 7/21/2014
0 4 7/22/2014
0 0 7/23/2014
0 0 7/24/2014
8 0 7/25/2014
0 0 7/26/2014
Desired out put
7/20/2014 7/21/2014 7/22/2014 7/23/2014 7/24/2014 7/25/2014 7/26/2014
Regular 0 8 0 0 0 8 0
Overttime 0 2 4 0 0 0 0
the workhourdate can change based on the user selection of dates. It is always 7 days. for example it could be between 7/13-7/20 or in this case the user want the report for 7/20-7/26
thank you