Pinting only first and last record 1

[dkaf]

I am creating a report that will print vehicle odometer readings. My field is {Meter1}. I am defining it by date. I need to print only the first odometer reading and the last odometer reading. I then need to calculate and print the total mileage between the two.

 

[synapsevampire]

Group by the auto (assuming that your doing multiple autos, you've stated nothing about the data here which is key to building a report...), then in the group header place this formula:

whileprintingrecords;
numbervar StartRead:= {table.meter1};

Then suppress the group header and the Details sections, and in the group footer place this formula:

whileprintingrecords;
numbervar StartRead;
{table.meter1}-StartRead

This will display the difference.

-k

 

[lbass]

You could probably just group by date and then create a formula for the group header or footer:

maximum({table.odometerreading},{table.date}) - minimum({table.odometerreading},{table.date})

-LB