reporting-services - SSRS 2012 表矩阵内的排序顺序

Question

我需要一些关于表矩阵/钻取报告、排序顺序的帮助。我的报告看起来像这样

Account      Name         JNumber       AmountNet  
0133266      New Jets                   12469.86   

AmountNet 是钻取数据的总和

您单击报告的名称 字段，它会打开如下

Account    Name       JNumber     AmountNet  
0133266    New Jets    1            900.00  
                       2            163.86  
                       3             90.00  
                       4          10506.00  
                       Total      12469.86  

我想做的是当报告处于其原始状态时，即在您单击任何名称以查看 AmountNet 的组成方式之前，按 AmountNet 对其进行排序 列降序。如果您需要任何其他信息，请告诉我。

Answer 1

您需要更改组的排序顺序。右键单击该组并进入组属性。使用排序部分按表达式排序:

=SUM(Fields!AmountNet.Value)

MSDN 有 this to say :

Tablix data region group. Set sort expressions for each group, including the details group, to control the sort order of group instances. For example, for the details group, you control the order of the detail rows. For a child group, you control the order of group instances for the child group within the parent group. By default, when you create a group, the sort expression is set to the group expression and to ascending order.