Search code examples
ssrs-2008reporting-services

SSRS - show row total in column

I am working on SSRS 2008.

I have a report as follows, I want the toal of Amount in Total column. I am not able to get total in column. I have tried Add Total / Sum() features of SSRS but no luck.

+---------+-------+--------+-------+                                          
|Supplier | Agent | Amount | Total |
+---------+-------+--------+-------+
|         | A10051| 237.2  |       |
|S2005068 +-------+--------+       |       
|         |A10052 | 23.8   |       |
+---------+-------+--------+-------+
Solution

  • I think your design is not proper. The total row in the last column will be under the details group. If you want a total on the last column you can get but for-each row it will repeat. use

    =Sum(Fields!Amount.Value,"Supplier") here Supplier is the "Group Name"

    To avoid this repeatition we need to add the total column inside the supplier group and use =Sum(Fields!Amount.Value) for total

    or

    Right click on the Amount column data -> Add Total -> Before or After. This will display the sub-total for the Supplier group in the same Amount column after/before as you selected.