Dear all, Here is my situation : I have a datasource with a row for each connection of a username in a system. I'm building a report with many statistics, and in the last tab, I want to display in a table the most recent connection date for each users. I've been fighting with this and can't stand it now. Using Rank does not work, since it either shows multiple dates for each users or only the group of users that gets connected on the most recent date (like today or yesterday). For those who got connected earlier, they are treated as "others" and not displayed ! I found a way to display the table properly but it ONLY WORKS when the date is converted to a number TreasAs...    First : basic table with names & date, you see that there are as many rows as date & username.   Second, if i try to create a rank on a TreasAs Date (number), then it only shows the group of people that get connected on the most recent day together, the others are treated separetly.       Then if I only put in the table the TreasAs Date (number), it WORKS ! I have my most recent date for each and all users, but in a numeric format !!! HELP !! thanks     ... View more

Dear all, I've got a report showing activities by sales person (each record = one activity). As you can see below, the cross table on the left shows the number of activities by month and by name. Now on the list on the right, I would like to add the most recent activity date for each sale person.  I've spend a lot of time trying to solve this but.... need your help now ! Thanks Victor     ... View more