Grouping Crystal Reports groups

I have flight data for each user. The table below shows an example for a single user ID. I need to group by user_id (show only one line for each user_id), which has the last flight.

When I added the user_id grouping, the correct flight date is displayed in the results report, but the remaining fields are taken from the last row for each user (highlighted fields). How can I show the whole row with the last date (4th row in my example)? Thanks!

enter image description here

+1
source share
1 answer

, , , , . SQL, Crystal , , , .

1. USERID (Report > Group Expert > USERID )

enter image description here 2. FlightDate (Report > Sort Expert > FlightDate Descending : FlightDate , , , Crystal 12/2015 1/2016 ()

enter image description here

3. , ( Crystal, , ) - " Total", "". , ; " " FlightDate, COUNT " " Reset ". " USERID

enter image description here

: enter image description here

  1. " " "" "" "", {#RecountCount} > 1 ( )

enter image description here

+2

Source: https://habr.com/ru/post/1620003/


All Articles