Search results for query: *

Thank you, briangriffin! I'll have to read up a bit on SQL commands, as I don't use them often. And do a little testing this weekend.I'll try to update on Monday when I can access the report again. Since I don't have access from home.

I have never used a command object before, so I would be interested to get your input on that. I just can't modify any of the tables or create any new joins, which if I understand correctly is what a command object avoids.

Unfortunately, that is not an option. I will need a purely Crystal solution if possible.

Another thing I tried was using a Top Nth sort. But I encountered the same issue of the first group breaking up the scores.

Yes, at my organization, we use an application called Crystal Corral by Groff Automation. Also, SAP offers Crystal Reports Viewer, which for me displays on the Start Page tab in Crystal Reports XI.

I attempted this solution and the report breaks the group into scores before evaluating the maximum value of the User ID group. Is there some way to have Crystal evaluate the the maximum score value before the first grouping is created?

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...