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!