regex

Report: Sub-summary

Discussion created by regex on Aug 13, 2016
Latest reply on Aug 15, 2016 by Johan Hedman

Hi Everyone,

 

I have been attempted to make a quick report on employees and their time.   I have created the sub-summary report that lists the Employee, Project and Time Details.  But, I want total the hours for date/time worked.  As example below.  I have it partially working, but I need a summary for each employee(s) time.  However, FM states that I cannot use a Summary Field in a Sub-Summary Part.  Any assistance would be of benefit.  Thanks. 

 

                                                                   Date: 8/13/2016

  Jane Doe

              Project X, Task Type, Number of Tasks, Date Start, Time In, Date End, Time Out, Total Hours

              Project Nissan, Clean Mats, 56, 8/13/2016, 8:00 AM, 8/13/2016, 11:59 AM,  4

              Project Nissan, Clean Mats, 12, 8/13/2016, 1:00 PM, 8/13/2016, 5:00 PM,    4

                                                                                                                                  Summary Hours:          8    

            

John Doe

              Project X, Task Type, Number of Tasks, Date Start, Time In, Date End, Time Out, Total Hours

              Project Nissan, Clean Mats, 56, 8/13/2016, 8:00 AM, 8/13/2016, 11:59 AM,  4

              Project Nissan, Clean Mats, 12, 8/13/2016, 1:00 PM, 8/13/2016, 5:00 PM,    4

                                                                                                                                  Summary Hours:          8    

 

 

 

Outcomes