Group: Administrators
Last Login: Yesterday @ 10:45:49 AM
Posts: 1,689,
Visits: 3,988
The following is a further customization of the Labor grid's Sample Schedulable Users Billing Hours with Grand Totals report to include displaying the difference in hours between the Service Stop Date & Time and Service Start Date & Time - such a field may be useful in checking that the actual hours worked are entered in the Billable Hours and No Charge Hours.
I would suggest filtering the Labor grid by the specific user (User field) and the date you wish to report on (Service Start Date & Time using a custom filter selecting greater than a date, and less than a date such as identified in the forum topic http://forum.ayanova.com/Topic1430-100-1.aspx?Highlight=greater+than)
Example of a print preview of this report template
The field xrLabel21 script property OnBeforePrint uses the following script
private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { //this gets the object value of the Stop Date & Time DateTime dt1 = Convert.ToDateTime(GetCurrentColumnValue("LT_WorkorderItemLabor_Label_ServiceStopDate")); //this gets the object value of the Start Date & Time DateTime dt2 = Convert.ToDateTime(GetCurrentColumnValue("LT_WorkorderItemLabor_Label_ServiceStartDate")); //this subtracts the start date & time from the stop date & time TimeSpan ts = dt1.Subtract(dt2); //this displays the timespan in total hours (if you want to display in minutes, than change TotalHours to TotalMinutes xrLabel21.Text = ts.TotalHours.ToString(); }
You cannot post new topics.
You cannot post topic replies.
You cannot post new polls.
You cannot post replies to polls.
You cannot edit your own topics.
You cannot delete your own topics.
You cannot edit other topics.
You cannot delete other topics.
You cannot edit your own posts.
You cannot edit other posts.
You cannot delete your own posts.
You cannot delete other posts.
You cannot post events.
You cannot edit your own events.
You cannot edit other events.
You cannot delete your own events.
You cannot delete other events.
You cannot send private messages.
You cannot send emails.
You may read topics.
You cannot rate topics.
You cannot vote within polls.
You cannot upload attachments.
You cannot download attachments.
You cannot post HTML code.
You cannot edit HTML code.
You cannot post IFCode.
You cannot post JavaScript.
You cannot post EmotIcons.
You cannot post or upload images.
Posted 4/20/2007 11:21:07 AM
