Crystal 8 - How to grab last 5 returns based on descending date

[ynott]

I have 40 vehicles within a field called Log.VehName. I have another field called Log.Date_Time. The third field is called Log.Mileage.

My goal is to create a report with Log.VehName as the group and to only see the last 5 reported mileages.

 

[Madawc]

Group by name. Sort details by time, descending. Do a running-total count. Suppress detail lines when the count is greater than 5.

Madawc Williams (East Anglia, UK)