How to perform row total and column total in rdlc reports

Hi All,

I want to perform the row total and column total of a rdlc report using the Matrix Tool.

Present RDLC Report Structure
-------------------
|City | Year |
-------------------
|City | Population |
-------------------

Output of RDLC Report

--------------------------------------------------------------
|City | 2011 2012 | 2013 | 2014 |
--------------------------------------------------------------
|Banglore | 9000000 | 9000970 | 9001166 | 9002008 |
--------------------------------------------------------------
|Hyderabad | 8001456 | 8001478 | 8001961 | 8002085 |
--------------------------------------------------------------
|Mumbai | 10010490 | 10012871 | 10012866 | 10013008 |
---------------------------------------------------------------
|NewDelhi | 10010120 | 10011011 | 10012016 | 10012708 |
--------------------------------------------------------------

Required Output

---------------------------------------------------------------------------------
|City | 2011 | 2012 | 2013 | 2014 | Total |
------------------------------------------------------------------------------------
|Banglore | 9000000 | 9000970 | 9001166 | 9002008 | 36004144 |
--------------------------------------------------------------------------------------
|Hyderabad | 8001456 | 8001478 | 8001961 | 8002085 | 32006980 |
---------------------------------------------------------------------------------------
|Mumbai | 10010490 | 10012871 | 10012866 | 10013008 | 40049235 |
------------------------------------------------------------------------------------------
|NewDelhi | 10010120 | 10011011 | 10012016 | 10012708 | 40045855 |
------------------------------------------------------------------------------------------
|Total | 37022066 | 37026330 | 37028009 | 37028009 | 148106214 |
-----------------------------------------------------------------------------------------

Please let me know how to create the RDLC Report Structutre for the above format.

Thanks and Regards
Santosh

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dhanunjay Jajimoggla12y ago
Accepted answer
Hi Santosh,

Follow below steps:

For Column Total ----> 1. Right click on your text box

2 . Choose Expression option
3. Select Datasets -- Double click on your particular field.

4. Change Expression like above

5.then ok.

For Row Wise total :

1.Right Click on your text box

2 . Choose Expressions

3 . Now write the Expression like below :

=Fields!2011.Value + Fields!2012.Value + Fields!2013.Value + Fields!2014.Value

4 . ok.