Hi Bob
I downloaded your report template and imported it, andopened it in the report designer
Your report templateis completely designed differently than Sample Schedulable User Billing Hours with Grand Total - you have no detailBand, your scriptsare all in the GroupHeader instead of referring to the actual datafields and databand, completely different setup then the sample report template provided- resulting in there not being a way with your report template to do what you want.
If you had instead followed the format of the Sample Schedulable User Billing Hours with Grand Total sample report template, than you would have been able to utilize similar scripts provided in that sample.
As it is, your report template can not use the scripts from Sample Schedulable User Billing Hours with Grand Total to get what you want. I would not know how to script towork with the way you have designed this report template as it is not following the standards laid out in the sample report templates that I have previouslyprovided.
I would recommend the following:
That you refer back to the Sample Schedulable User Billing Hours with Grand Total - make a copy of it (named Client Billing Hours with Grand Total for example), and customize it with the fields you want to see.
For example, instead of groupHeaderBand1 displaying by Schedulable User - change it so it is by Client. Change the datafield xrLabel2, and in property of groupHeaderBand1 itself, change the GroupFields Collection to sort by Client, not by User.
In detailBand1, remove the data fields you do not want (Service Rate, Rate Unit, etc), and add in the ones you do (Workorder Category, Summary etc) leaving the NoChargeQuantity and Service Rate Quantity as these already are referred to in the script in the detailBand1 script property OnBeforePrint
In GroupFooter1, remove the table cells you do not want to show (Total Net For This User, etc), perhaps also changing the text of the label fields for No Charge Total and Billable Total for that client - as well as perhaps move the fields to the right so they line up under the No Charge Hours and Billable Hours from the detailBand1 band.
In ReportFooter, remove the fields for xrGrandTotal and Grand NetTotal for All as this is no longer being processed.
And then you would have your report template that shows no charge hours and billable hours per client, plus a total of those two per client, and then a grand total of all billable hours and no charge hours at the very end of the report template.