SSRS Tablix Sorting w/Row & Column Group

My matrix has a row group (QuestionText) and a Column Group (AnswerText).

It looks like this:

                [AnswerText]
[QuestionText]  [AnswerCount]

My Data looks like this:

QuestionText    AnswerText     AnswerCount
Question 1      Yes            2
Question 1      No             1
Question 2      Yes            3
Question 2      No             4

Which renders as follows:

                Yes            No
Question 1      2              1
Question 2      3              4

What I'd like to do is to sort by the Yes or No. Please note that both the questions and answers are just examples, they answers could be flag colors & r开发者_如何学编程ed, white, blue...

Is this possible? I've seen someone say "it's hard". I'm ok with hard, I just need to know how. http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/b4a242ce-e2de-463e-8732-a9f8abe493e4

Thanks for looking!

did you try just adding an order by in your sql? so you would order by QuestionText then AnswerText.

I might not be grasping this correctly, but do you just want to sort by ascending/descending # of Yes's & No's?

Try this... Go to the answertext header, and right click, then in the properties, go to the interactive sorting tab.

Select "Groups" instead of Details (radial button). In the sort by: box, select your answer text group. In the last section, where it says: apply this sorting to all groups and data regions in: Select your entire matrix/tablix. Not positive, but I had a matrix and that last step was the key to sorting it...in drilldowns or groupings, etc..., sorting only works if you apply it to the whole tablix.