Need to Sort Grouped Data in SSRS Report

Hello experts,
I have data that is grouped as follows:

Group Name     Channel Name    Score
==========     =============   =====
Group XYZ                                        400
Group XYZ        Channel #1           150
Group XYZ        Channel #2           250
Group ABC                                        700
Group ABC        Channel #1           300
Group ABC        Channel #2           400

I need to sort this data descending on the Score field in an SSRS report, both on Group level and child (channel) level, so the above data will look as follows:

GroupName     ChannelName    Score
==========     =============   =====
Group ABC                                        700
Group ABC        Channel #2           400
Group ABC        Channel #1           300
Group XYZ                                        400
Group XYZ        Channel #2           250
Group XYZ        Channel #1           150

The query used for pulling this data is as follows:

Group Name     Channel Name    Score
==========     =============   =====
Group XYZ        Channel #1           150
Group XYZ        Channel #2           250
Group ABC        Channel #1           300
Group ABC        Channel #2           400

and the data is grouped by GroupName in SSRS.

Appreciate your help,
Hani
MehawitchiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DcpKingCommented:
Not all fields actually have to be visible, so you could add a GroupTotal field in the code that prepares the data for display, and arrange that the value of that be the value of the group total. Thus ordering elements first by this new GroupTotal field and then by the score would produce what you're looking for.

hth

Mike
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MehawitchiAuthor Commented:
Thanks DcpKing - I was able to solve this problem by adding a Group in the report and sorting by Sum(Score), as opposed to Score only
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.