Report Builder 2.0 按值列排序
我有一个向下钻取表，可以按“组”列排序，但按“值”列（数量）排序不起作用。
我右键单击标题，选择文本框属性，选择交互式排序，选择详细信息行，选择按数量排序。我还尝试了可用选项的所有排列。有什么技巧可以让它发挥作用吗？
编辑：我发现这个漂亮的图表说明了在不同的排序场景中要做什么： http://msdn.microsoft.com/en-我们/库/dd207011(v=sql.100).aspx 如果我是图表的第三种情况（不确定），那么是“子组标题行”吗？
I have a drill down table and I can sort by the Group columns, but sort by the Value column (Quantity) doesn't work.
I'm right-clicking the header, selecting textbox properties, selecting interactive sorting, selecting Detail Rows, Selecting Sort By Quantity. I've also tried every permutation on the available options. Is there a trick to getting this to work?
Edit: I found this nice chart saying what to do in different sorting scenarios:
http://msdn.microsoft.com/en-us/library/dd207011(v=sql.100).aspx
If I'm the 3rd case (not sure) of the chart, then was is a "child group header row"?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我想通了。对详细信息进行排序并不像对组进行排序那么简单。它看起来像上面链接的图表中的第四种情况。步骤如下：
1) 右键单击列标题，选择文本框属性，选择交互式排序。
2) 在“启用交互式排序...”下选择“组”
3) 选择要排序的父组（详细信息列不是组，因此不会列出）
4）（技巧）在“排序方式”下，使用作为排序依据的数据集字段聚合的表达式，在我的例子中是： =Sum(Fields!Quantity.Value)
排序详细信息并不是真正像排序那样点击团体。我已经看到了一些其他未答复的类似问题的帖子，所以我希望这对其他人有帮助。
I figured it out. Sorting Details is not as simple as sorting groups. It looks like the 4th scenario in the chart linked above. These are the steps:
1) Right click the column header, select textbox properties, select interactive sorting.
2) Select Group under Enable Interactive Sorting...
3) Select the parent group to sort (the detail column is not a group so it's no listed)
4) (the trick) Under Sort By, use an expression that is an aggregate of the dataset field to sort by, which in my case was: =Sum(Fields!Quantity.Value)
Sorting Details is not really point and click like sorting Groups. I've seen a few other unanswered posts with similar issues, so I hope this helps someone else.