Do note that the Meter Reading grid needs to be sorted by date (oldest entry first) before printing the report template so that the subtraction is correct.

Download the Sample Meter Reading Report With Difference

Import into AyaNova and access from the Meter Reading sub-grid for a unitl. If you open the report template using the report designer, you can see where the specific scripts were used to identify the difference.

actual script text is as follows:

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{

//This subtracts the present Meter Reading from the MeterReadingPrevious to get the DifferenceByDate amount
DifferenceByDate = Convert.ToDecimal(GetCurrentColumnValue("LT_UnitMeterReading_Label_Meter"))- MeterReadingPrevious;

//this puts the amount of the DifferenceByDate into the field
xrTableCell6.Text = string.Format("{0:n0}", DifferenceByDate);

//This keeps a copy of the UnitMeter Reading for the next record to use
MeterReadingPrevious = Convert.ToDecimal(GetCurrentColumnValue("LT_UnitMeterReading_Label_Meter"));

}

AyaNova Sales & Technical Support

http://www.ayanova.com