I'm using Visual Studio .net 2008 to build my Crystal Reports. I have a simple table that shows training records of people. Training takes 5 days to complete, and each day has a record in a SQL database. I can display all the data, but want only to show the last day that someone was trained. For example, if person1 was trained for 4 days and person2 was trained for 5 days, I only want to see day 4, and day 5 (respectively) and not days 1, 2, 3, 4 and 1, 2, 3, 4, 5. How can I do this in Crystal Reports? Or do I need to do this on the database side by building a new view and inserting some SQL?
Any help is much appreciated!!