Thanks

Please export a copy of the report template, zip it using WinZip and attach so I can import it and see what report template you are referring to and what is occurring in it.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

The problem has been fixed by your recent posting

http://forum.ayanova.com/Topic2142-103-1.aspx

Thanks

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Joyce, I downloaded this report that you modified. Thank you again for this! I was going through the report template after I imported it and noticed that the Summary at the bottom, just below the client signature, for the No Charge hours does not show up even when there are hours that should be totalled there. I took a quick look at the scripts, but could not see why they were not visible. Any help is always appreciated. Thanks in advance!

I will take a look and post back

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I see what is going on - let's say you have two Labor records, one is a No Charge Hours followed by an actual charge of hours, than what will occur with this report template is that it won't show the no charge total at the bottom of the report.

If you have only No Charge hours, than the no charge total at the bottom of the report template will display correctly.

I will look into why it is doing this and post back.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

1. Added the following to the OnBeforePrint for the DetailReportItemLabor band

//declare the variable as zero for use in the groupfooter for Labor
decimal WONetNC = 0;
private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {
}

2. Added the following lines to the OnBeforePrint for the xrLabel15 field

//this maintains a running total of hours for the groupfooter for this workorderitem
WONetNC += Convert.ToDecimal(NCQty);

3. Removed the existing OnBeforePrint and OnSummaryCalculated scripts for xrNetNCSum, as well as removed the data binding to the NoChargeQuantity data field, and removed the Summary settings for this field

4. Added a OnBeforePrint script for xrNetNCSum so it displays the running total of WONetNC, or if zero, doesn't display at all

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
if ("0.00"==(string.Format("{0:n2}", WONetNC)))
 {
 xrNetNCSum.Visible=false;
 }
else
 {
 xrNetNCSum.Visible=true;
 xrNetNCSum.Text = string.Format("{0:n2}", WONetNC);
 }
}

5. Edited the OnBeforePrint script for xrNetNCLabel with the following

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
if ("0.00"==(string.Format("{0:n2}", WONetNC)))
 {
 xrNetNCLabel.Visible=false;
 }
else
 {
 xrNetNCLabel.Visible=true;
 }
}

6. Added an OnAfterPrint script for the groupfooter for  with the following to zero out the WONetNC for the next workorder item

private void OnAfterPrint(object sender, System.EventArgs e)
{
WONetNC = 0;
}

Download the new March1 Sample Service Workorder with No Charge Amount

AyaNova Sales & Technical Support

http://www.ayanova.com