Maximum value as selection filter 3

[dhamspec]

Hi, I am new to Crystal and have been looking around today but haven't been able to find an answer to this. I am want to use a maximum value as a selection criteria. Ie output has multiple records based of accounts for all purchases, IE

Acct Number Purchase Date Purchase Id Purchase Item
55555 1/13/1999 231 Golf balls
55555 7/26/2001 498 Golf Clubs
55555 6/30/2004 598 Golf Tees

What I want it to select is only

Acct Number Purchase Date Purchase Id Purchase Item
55555 6/30/2004 598 Golf Tees

Based either on Most recent purchase date or highest purchase ID number.

Can anyone help
Thanks, D

 

[synapsevampire]

You should at least post your software version with any technical post.

Group by the Account Number, and then go into the Report->Edit Selection Formula->Record and use:

{table.date}=maximum({table.date},{table.group})

-k

 

[dhamspec]

Hi sorry I am using Crystal v 9. When I added the formula as indictated above I get an error message saying "this function cannot be used because it must be evaluated later

 

[lbass]

This formula belongs in a different area, and I'm sure SynapseVampire just made a typo. Go to report->edit selection formula->GROUP and enter it there. This also assumes you have a group on {table.acct}.

-LB

 

[synapsevampire]

Right as usual, LB, thanks.

-k