Liveware Publishing Support Forum

I have a report that is displaying all entries in a database. ie:____Unit NO Miles__102 1012__102 1098__102 2099__125 3055__125 3255____In this example I would only want to display the record which has the highest number of miles for each unit number. I am not a novice to RR but don^t know how to solve this issue.____In other words I want the report in the example above to look like:____Unit NO Miles__102 2099__125 3255____Thanks for any suggestions.

The easiest way to do this is to sort the report by:__Unit No__Miles ____and then group the report by Unit No.____On the report layout, you need to move the Unit NO and Miles fields from the Record band to a Group 1 Unit No footer.____Since we have sorted the report by Unit then miles, the value that will print on the Unit footer is the record with the highest number of miles.____There are other ways to get there but again this is the easiest.____Kathleen__R&R Support__