CR 9 - Using Next function in a grouped report 1

[JanetStackpole]

I have a report listing fuel transactions grouped by vehicle id . It has the following columns

Vehicle id | fueling date | gallons | cost | odometer | miles between fueling |

I am using {odometer} - Next({odometer})to calculate the miles between fueling. This works very well until the vehicle id changes. It then calculates the difference between vehicle 1's odometer and vehicle 2's odometer.

eg vehicle id | date | gallons | cost | odometer | Miles between
32-101 3/11/06 10 20.00 90,000 200
32-101 3/1/06 10 20.00 89,800 19,800

32-102 3/9/06 10 20.00 70,000


Is there a way to correct this?

Thank you very much

 

[BobSuruncle]

Try something like this:

If {VehicleID} <> Next({VehicleID}) then
{odometer} - Next({odometer})
else 0


Bob Suruncle

 

[Madawc]

Surely

If {VehicleID} <> Next({VehicleID}) 
and {date} <> Next({date})
then 
{odometer} - Next({odometer})
else 0

You could also try grouping by Vehicle ID and then date, and doing something with maximum/minimum values.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[JanetStackpole]

Bob,

Thank you very much.