6 Replies Latest reply on Aug 15, 2016 5:43 AM by Johan Hedman

    Report: Sub-summary

    regex

      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