开发者

How to sort a report by a calculated field

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)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜