Crystal Reports - storing values from first and last record
Posted on 2005-03-24
I have an application reads and prints fuel records from a ADO dataset (push method). Each record contains an odometer reading. At the end of each group (vehicle unit), I need to be able to calculate the miles used buy subtracting the starting odometer reading from the ending odometer reading.
My problem is that I cannot figure out how to store the odometer reading from the first and last record of the group for this calculation.
I have considerd passing the miles traveled as a parm but I would have to pass in an amount for each unit ... and that could get real messy.
I also examined some of the totaling options and have tried but to no avail.