SSRS Tablix Sorting w/Row & Column Group

Question

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 & red, 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!

Answer 1

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