Sum of Column Values in Reports Automatically Using Expression in .NET

insert into Employee (Name,Salary)values('E',10000)

insert into Employee (Name,Salary)values('F',70000)

insert into Employee (Name,Salary)values('G',40000)

Select * from employee

Step 2: Create a page named "Default.aspx" with "ScriptManager" from the Ajax Extensions section, "SQLDataSource" from the Data section and "ReportViewer" Control from the Reporting section.

Bind the table columns with a "SQLDataSource" to access the data.

Step 3: Add a report named "Report.rdlc" and bind the dataset into the reports using Table.

Run the "Default.aspx" after adding the report named "Report.rdlc" to the "ReportViewer" control.

Purpose: I want to total the salary, in other words what is the total salary?

Solution

To do that I will use an "Expression" named RowNumber.

1. Insert a new row on the following side that will be outside the group:
   
   
   
   Note: The Outside Group will create the single row after all the group rows whereas an Inside Group will create the single row after every single row within the group.
   
2. Create the expression by right-clicking on that column and typing the total in the first column:
   
   
   
   
3. Select the "Aggregate" subcategory in the "Comman Functions" category and "Sum" as an item, then the expression will be like:
   
   =Sum(
   
   
   
   Then select the "Fields" as category and "Salary" as values, that will look like:
   
   =Sum(Fields!Salary.Value)
   
   
   
   Click the "OK" button.
   
   
   
   
4. Run the "Default.aspx".