I am a novice crystal reports user struggling with what must be a common obstacle. Hopefully I can articulate this well enough to make sense. Any help is appreciated:
 
I have a report that displays a list of users and the courses they have completed. Some users have completed a course multiple times. To eliminate these records, I am using a distinct count to only count each course title once per user:
 
DistinctCount (CourseTitle, Username)

 These records are then grouped by manager, where I would like to summarize the DistinctCount for all of the individual users. This count should maintain the distinct course title count per user, but allow a single course to be counted for each user it is evaluating. How can I create a summary by manager?

Thank you.

Jon



Edited by jonberardi - 02 Nov 2009 at 10:44am

Thank you, DBlank - your suggestion works perfectly!

Jon