Last record formula

[ImArchimedes]

Is there a function to pull in a value from the last record of a detail band?

Here's a little background incase I'm approaching this wrong.

I'm pulling a number of odometer readings into a report in the detail band under a grouping by vehicle. I'm trying to pull in the difference between the first record and last so I can find total miles traveled by said vehicle.

I can get that much done using shared variables but the trick is adding all the total miles traveled for all the vehicles at the end of the report. It won't let me summarize the totals field because, I think the formula to get last record is so dynamic. The shared ending odometer variable changes with each vehicle so adding it up at the end is impossible.

Is there some way to, formulaicly call on value in the last record of the detail band? I tried "Lastrecord({veh_odometer})" and variations like "Recordlast" but no luck. Is there a function to pull last record? I would think there would be.

Sorry this is so long. Thank you to anyone who even read this far into this.

 

[PatriciaObreja]

If you want to know which is the last record in a group which is grouped by vehicle create a formula like this:
if {Vehicle.VehicleID} <> next({Vehicle.VehicleID}) then
"last"
else
"not last"

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[lbass]

If you have a group on vehicles, then you should have a final display formula in the group footer, like this:

whileprintingrecords;
shared numbervar miles;

(You don't need the "shared" unless these values are coming from subreports.) Then just change this formula to:

whileprintingrecords;
shared numbervar miles;
numbervar totmiles := totmiles + miles;

Then in the report footer, use this formula:

whileprintingrecords;
numbervar totmiles;

-LB