title: Crystal Reports group sorting
body: <p>I have flight data records for each user. The table below shows an example for one user id. I need to group by user_id (show only one row for each user_id) that has the latest flight_date.</p>
  
  <p>When I added grouping by user_id, the result report displays the right flight date, but the rest of the fields come from the last row for each user (highlighted fields).How do I make it show the entire row with the latest date (4th row in my example)? Thank you!</p>
  
  <p><a href="https://i.stack.imgur.com/2lPjr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2lPjr.png" alt="enter image description here"></a></p>