max dates in a CR

[JamesFlowers]

I have a report that produces this format of data

Val Real_ship Val_valid_from
0.11 20/02/2001 01/03/1999
0.01 20/02/2001 01/01/2001
0.02 20/02/2001 01/02/2001

the record I require is line three (as the Real_Ship is after the Val_valid_from)
I need to select the latest date of Val_valid_from

I have tried maximum(Val_valid_from) and this returns [NEEDS A BOOLEAN].

how do I select the latest Val_valid_from? to return just

Val Real_ship Val_valid_from
0.02 20/02/2001 01/02/2001


Many Thanks in advance

James Flowers

http://www.trikon.com

 

[kenhamady]

(Val_valid_from) = maximum(Val_valid_from)

This goes in the GROUP selection formula.

It will still pull all three records (and they will also get into the totals unless you use running totals), but it will only print the max record. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)