I have a simple report made with FetchXml that shows something like this:
EMPLOYEE NAME AUTH TOTAL DRAFT TOTAL
new_UserName Exp1* 开发者_开发百科 Exp2*
*Exp1:
=FormatCurrency(Sum(Fields!lead1_new_totalauthorizedamountValue.Value))
*Exp2:
=FormatCurrency(Sum(Fields!lead1_new_totalfeescollectedValue.Value)- Sum(Fields!lead1_web_totalrefundamountValue.Value))
Here is the issue: I can't realize how sort the whole table by Draft Total or by Auth Total.
For each group, go to properties, and in sorting enter the expressions you mention.
For the detail, go to properties and in sorting use the same expressions without the aggregation (SUM)
精彩评论