I am having a problem with creating a new "Total Hours spent" column to the Sample Schedulable User Billing Report with Grand Total .  The total hours spend is the difference between the Labour Service start date &Time and service stop date & Time. This is either displayed in hours or minutes. This will help to identify some discrepancies on the true non chargeable time for the technician

I would also like to break the group by date if possible. So I can see my daily hours total.

Many thanks,

Raymond Widjaja

I will have to get back to you on this - I'm pretty sure there is C# code to subtract date/time values from each other, and will have to play with it to determine exactly how it could be done.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I have posted a new sample report template at http://forum.ayanova.com/Topic3035-103-1.aspx that shows using a OnBeforePrint script for a field to subtract the Service Start Date & Time from the Service Stop Date & Time.

As groupings via the report template are based on a single datafield and either the Service Start Date & Time or the Stop Date & Time is a specific time of a specific date, it is not possible to set a grouping for an entire day. I would suggest that if you want to view hours for a specific day, that you set a custom filter selecting greater than and less than (example check out http://forum.ayanova.com/Topic1430-100-1.aspx?Highlight=greater+than  to display all records for a specific day for the user, and than select to print.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

The report does the trick. I can use it as a base.

As to the grouping, is there away to group by week  or month within a filter date range ? Curently I had to generate the report filtered by each week or month date-range.

Raymond. 

Refer to the topic http://forum.ayanova.com/Topic1430-100-1.aspx?Highlight=greater+than suggested above, which shows an example of how to create a custom filter selecting Operator of Less than or equal to and Operand of last date of service of the range you want to report on; and Operator of Greater Than or equal to and Operand of first date of service you want to report on.

The grid will than show all records that have this date between the two dates selected.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com