variable highest value

[greenockboy]

Hi

 

I have a report that retrieves records based on a join between two tables.

These records are crossed referenced with records from a third table and a status value retrieved from the third table using a scriptlet method.

The status value is then assigned to a variable I have created in ireport.

I would like to know which record from each group has the highest status value but without success.

I have tried creating another variable and setting the calculation type to highest out but it appears to be impossible to do this with a variable as opposed to a field value.

Any help would be very much appreciated.

Thanks

GB