A suggestion may be to use the Record Last Modified field in a detailed report template - as whenever you modify a service workorder, that field gets updated. And once you checkmark the Closed field in a workorder, you can not modify the workorder any more so it could be the closed date.

Of course, if you log in as the AyaNova Administrator and uncheck the Closed, and then Close it again, do note that the Last Modified Date will be changed - so kept that in mind.

Or another suggestion is to use the Labor's Service Stop Date & Time field.

Or if you do not neccesarily complete service for a workorder the same day you check the Closed field of the workorder or you have multiple Labor items in a workorder that all have different stop date/times, you might want to use another date field such as the Close By Date field so you specifically set the date and time closed.

Do to take a look at the sample at http://forum.ayanova.com/Topic3035-103-1.aspx for subtracting dates.

Also check out the sample detailed type report template installed with AyaNova for use with the Service Workorder grid and Items grid Sample Labor from Request Date Average Response Time as it too shows an example of the scripts you can refer to in the Before Print script for the Detail1 band and Before Print script for the Report Footer band.

Or if you would like me to create this custom report for you, or create a custom script for you, send details as per http://forum.ayanova.com/Topic3447-100-1.aspx and I can quote for you.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

0 was being returned because the GetColumnValue needed to be identified as getting the data for the detailReportBand1

Edit your script so that it includes the detailReportBand1, save and now preview.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Hi Mospan

If wanting to format a string that is actually a number of the total hours derived from such a script, I did a search online and found this web page that gave example to use http://www.csharp-examples.net/string-format-double/ - so would use:

xrLabel3.Text = String.Format("{0:0.00}", ts.TotalHours);

(previously you had xrLabel3.Text =  ts.TotalHours.ToString(); which just converted the ts.TotalHours to a string, whereas the above line converts to a string that is formated with two decimal points 0.00).

If you would like me to create custom scripts to determine your Report Summary fields, I would be happy to do so. Let me know, and I will send you a quote to your email address. Otherwise, a suggestion would be to do a search through existing posts for similar, as well as searching online for C# formatting and scripting examples etc, but providing this would be outside our free support.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com