SSRS Tablix 排序（带行和行）列组
我的矩阵有一个行组（QuestionText）和一个列组（AnswerText）。
它看起来像这样：
[AnswerText] [QuestionText] [AnswerCount]
我的数据看起来像这样：
QuestionText AnswerText AnswerCount Question 1 Yes 2 Question 1 No 1 Question 2 Yes 3 Question 2 No 4
呈现如下：
Yes No Question 1 2 1 Question 2 3 4
我想做的是按是或否排序。请注意，问题和答案都只是示例，它们的答案可以是标志颜色&红、白、蓝……
这可能吗？我看到有人说“很难”。我可以接受困难，我只需要知道如何做。 http://social.msdn.microsoft .com/Forums/en/sqlreportingservices/thread/b4a242ce-e2de-463e-8732-a9f8abe493e4
感谢您的浏览！
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!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是否尝试在 sql 中添加 order by ？所以你可以先按 QuestionText 然后按 AnswerText 排序。
did you try just adding an order by in your sql? so you would order by QuestionText then AnswerText.
我可能没有正确理解这一点，但是您只想按 Yes's & 的升序/降序排序吗？没有吗？
试试这个...转到答案文本标题，然后右键单击，然后在属性中转到交互式排序选项卡。
选择“组”而不是“详细信息”（圆形按钮）。
在排序依据：框中，选择您的答案文本组。
在最后一节中，它说：将此排序应用于以下位置的所有组和数据区域：
选择整个矩阵/tablix。不是积极的，但我有一个矩阵，最后一步是对它进行排序的关键......在钻取或分组等中......，排序仅在将其应用于整个 tablix 时才有效。
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.