Hello!
First time poster, so I apologize for any errors in advance.
I am having some difficulty displaying only the top value within a group.
I currently have the report formatted as such:
Group # 1: (Scores)
Details (User ID) (Name) (Scores)
Group # 1 has a specified order of:
0 -25
26 - 50
51 - 75
76 - 100
Each user takes a test and has the ability to take the test more than once.
I am attempting to only display the top score for each user and then group the scores.
The problem is a person can be in multiple groups, for example if they score a 20 and a 55. I only want to show that person's 55 and disregard the 20.
I am running Crystal Reports Ver. 11
Thanks!
-D
First time poster, so I apologize for any errors in advance.
I am having some difficulty displaying only the top value within a group.
I currently have the report formatted as such:
Group # 1: (Scores)
Details (User ID) (Name) (Scores)
Group # 1 has a specified order of:
0 -25
26 - 50
51 - 75
76 - 100
Each user takes a test and has the ability to take the test more than once.
I am attempting to only display the top score for each user and then group the scores.
The problem is a person can be in multiple groups, for example if they score a 20 and a 55. I only want to show that person's 55 and disregard the 20.
I am running Crystal Reports Ver. 11
Thanks!
-D