Display filtered data

So whats the issue?

There can be two ways to do it:
1. Only get those data from database that has this maximum value condition. Thus, SQL query would have a filter.
2. In crystal report, you can use Formula Fields. You can make any expression you want to and display accordingly.

For filtering data in Crystal report, have a look at this [^]sample.