How to sum an expression outside of aggregate ssrs

Question

My current table has a grouping by Client's and the tablix displays all transaction's per each client and Total per client. On the bottom of the tablix I have a grouping to sum each client's Amount but I'm having trouble for the Report Total Suming because it's an expression.

The expression is

Total Expression =Last(Fields!Balance.Value, "TransactionDTO")

and it grabs the final balance row and sums it instead of summing all transaction rows.

My question is how do I sum that expression? My ReportTotal row, Total column should be something like below but that didn't work.

ReportTotal Expression = Sum(Last(Fields!Balance.Value, "TransactionDTO"))

Valid XHTML

Sorry, for clarification, is the bottom row summing the total of all Clients together into a single value? — Jonnus
The final row, Report Total, is summing all the totals of clients together Except I want the empty box at the moment to sum the expression — Master
@Master Why you are not handling Total(Balance) column same way as amount column? =SUM([Balance]) If you can provide a sample output it will be easier to find a solution. — Anup Agrawal

Hannover Fist Hannover Fist · Accepted Answer · 2015-09-02T23:09:08

I think you'll need code to make it work the way you want.

Public Total As Decimal

Function AddTotal(ByVal Money as Decimal) as Decimal
Total = Total + Money
AddTotal = Money
End Function

For the detail rows, use

=code.AddTotal(Last(Fields!Balance.Value, "TransactionDTO"))

The code will track your individual balances and output the same value for the detail.

And for the total,

=code.Total

How to sum an expression outside of aggregate ssrs

1 Answers