CODEWITHSUNDEEP
reporting-services
Master
Master

Reputation: 2153

How to sum an expression outside of aggregate ssrs

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

Upvotes: 1

Views: 1336

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

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

Upvotes: 2

Related Questions