Print latest record within a group on a report

[ghnat]

I am trying to design a report that only displays the latest(date or invoice number) record based on a grouping within the report. Example - My report has invoice data for each sales person and all sales people could have numerous invoices for the month but I only want to print one (the latest) invoice record for each sales person within the month.

Any assistance would be greatly appreciated!

Thanks

Gary

 

[CoSpringsGuy]

just sort by ascending date, put your fields in the group footer and suppress details

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection