Maximum of field not in group formula

[djieon]

Hi All,

I have a report that has a row with a unique ID for each item, but can have several records against each ID with a date tested, IE unique ID '1' may have been tested on 07/05/2010, 07/05/2011 and 07/05/2012 so there is 3 records against ID 1.

I want a way of the report to only bring back the latest test, so at the moment I am using the formula

maximum ({RM_INVENTORY_ELECTRICAL_TESTING.ELECTRICAL_TEST_DATE},{RM_COMMON_ATTRIBUTES.ITEM_UID})

This is ok but my problem is that I then want to be able to sort in the order of the earliest test first (so i can find out the most overdue tests!) at the moment becuase the group is on the unique ID I cant get it to sort in the order I want?

Is there a way to put this in the record select instead of in a group? or a better way of doing this...

Thanks in advance.

David.

 

[CoSpringsGuy]

yeah ... I am having a hard time testing this with my data.. let me look some more.

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection