Adding Total in Last Row as Grand Total in SSRS Report
Many times in your Report you have a requirement like to show grand total in the last row.Its very simple
in SSRS.
Let us suppose you are displaying Salary of Employee and in the last Row you want to show the total of all salaries
Below are the steps.
Suppose you have a report like this
EmployeeName EmployeeSalary
Amit 10,000
Vikash 20,000
Ajay 30,000
Sumit 40,000
--------------------------------
TotalSalaries 1,00,000 --This you want to add in your Report
Go to Report designeer
Add a New row in SSRS Table
Right click Table Properties
--ADD New Row
--Outside group
In New Row first column-Total Salaries
In New Row Second Column =Sum(Field!EmployeeSalary.value)
Click Ok
Preview The Report
The Report will have a new Row with displaying Sum of Salaries.
True! Also if you want the grand total to show on each page after page break instead of Outside group you need to create an Inside group. In there you need add scope to the field in SUM function as in following example: Sum(Field!EmployeeSalary.value, "field dataset name")
ReplyDeleteYes that's correct
ReplyDeleteSomehow it does not works for me:
ReplyDeleteI created a report where I have different branches and each branch has many employees;
So I print details records and on break in branch I have totals for a branch. Now I want at end of report to add totals for all all employees in company.
I tried to add a group - company as parent of branch, but it did not work
zalek bloom
Did you ever get this work? I'm looking to do the same thing. I have a page for each account. At the end of each page I have an account total. Now I am looking to add a total at the very end of the report for "ALL" accounts.
DeleteWorks for me. Thanks!
ReplyDeleteIt doesn't works for me as well.I have data in nvarchar in SQL and I have converted it to integer in SSRS ,Now i want to displays its sum at bottom and I get #error all the time.Warning 1 [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox159.Paragraphs[0].TextRuns[0]’ contains an error: Input string was not in a correct format.
ReplyDelete