How to display most resent record from the groop..

[vlad2]

I need to show Customer with the list belonding to him vehicles.Each vehicle has number of invoices.I need to calculate total of all invoices. that's why i load all invoices for the vehicle, but i need just show one, MOST RESENT Invoice.

How i can select one, most resest invoice, that was saved?

thank for help

 

[dgillz]

Sort your records so that the most recent invoice shows at the top of each customer, then drag the fields you want to display to the group header. You can keep the details hidden if you like, but the database fields in the group header will return the first record, or the most recent invoice, if you set up your sorting correctly. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[vlad2]

Thanks i've resolved the problem following the same steps as you've recomended me. thanks...