Add total count for SSRS report.

1. This is how you can add total count for the SSRS report. For my table, I don’t have a count field. Also since I am new to SSRS, I put some creative by playing with the columns just to get the total do able and to experience how can we use the totalize functionality. I found that we can only use the ‘add total’ on certain field / column. Let’s put that into another discussion, I will first create an aggregate column to make it works.

2. I added a calculated field with name ‘count’. Click on the ‘fx’ and fill in the value ‘1’.

3. Drag and drop the count column to the table. Right click on the count and select ‘Add total’.

4. You can check your report in the preview. In this sample, the way this report is being display doesn’t make sense. So, I move the sum to another column, remove all the other columns except the employeeId.

5. Add grand total.

6. You will now have subtotal per employee, and a total of all training request for all employee.

How to create SSRS Report.