Minimum/maximum selection in Crystal report 1

[lana123]

Hi, people.
I work with Crystal report 11(sometimes Crystal 9), Oracle 9 db.
I'm sure I'm not the first who has problem with minimum/maximum in Crystal.
I don't have possibility to get the minimum/maximum records through the view because my reports are based on business view in Crystal 11.
I need to show only maximum (Transaction_date) records in my report.
I don't want to use function WhileprintingRecords that only let to use minimum/maximum in Crystal, I want to see these records and print them.

I'll appreciate any help.
Thanks in advance,

Lana

 

[GJParker]

Create a group at the level you want to see the maximum transaction date for and then enter a Group selection Formula, Report menu -> Selection Formulas -> Group

Enter the selection formula

{Transaction_date} = maximum({Transaction_Date}, {Your Group})

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lana123]

Thank you very much.

Lana