|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/11/2009 3:46:53 PM
Posts: 13,
Visits: 28
|
|
I created a report in which I am listing multiple "workorder item types" for the various repairs needed on 1 item. I have labor rates for each, but I do not want to show them individually on the quote, I just want 1 total cost of all labor at the bottom. How can I do this?
Thank you
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190,
Visits: 5,029
|
|
| Hello Take a look at the sample report templates that come with AyaNova, such as the Sample Detailed Quote and the Sample Detailed Service Workorder with Grand Total In the Sample Detailed Quote report template for example, click on the Sum of Line Total field in the GroupFooter3 band and view its the Script property for Summary Calculated (click on the field xrTableCell47, view the Properties tab, expand the Scripts property, click on the Summary Calculated script so that you can see the script it has in it) Now click on the xrNetLabor field in the ReportFooter1 band, and view its Script properties for Before Print - you will see that it has a script to display this running total it has obtained. What this shows you is that for the total of all labor to be shown in the report footer, the report has to get and show each labor's Line Total. If you do not show the Line Total for each labor record, then the report has no way to be able to get the total of all of those Line Totals. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
Posted 10/6/2009 11:16:20 AM
