Finding Last Date

[bld21]

I am using crystal 2008 and I have a field called {payment.pmt_eff_date}. The report will show an account with various dates of payments made. I need to only see the date of the last payment made. Is there a formula to select only the date of last payment made?

Thanks,
Bruce

 

[lbass]

Insert a group on account and then go to report->selection formula->GROUP and enter:

{payment.pmt_eff_date} = maximum({payment.pmt_eff_date},{table.account})

Only the most recent record will appear per count. However, if you intend to do calculations, you must use running totals, since non-group selected records will still contribute to the more usual inserted summaries.

-LB