try a stored procedure. you can perform multiple sql commands there, not just 1 select.
CR can't do it, as the MAX function is an aggregate, and is not evaluated in the 2 passes through the data the CR performs before display.
If it is just a display issue, you could suppress all the rows that don't match the desired value (max()). If you want to use aggregates, like SUM on the data, you would need to code your own running totals via formulas or running totals as SUM will will include all the values you supressed as well as the ones displayed.
HTH
IP Logged
