Problem with getting totals in Report Builder 3.0

Question

Hi all,

I am using a Microsoft SQL Server Report Builder 3.0 to build a report. I want to group by department name and hire date and then display total salary for each hire_date and department name. I have successfully created the two groups, by when I right click to add totals, the 'Add Total' option is grayed out. Any thoughts what I am doing wrong?

Thank you,

Seyed

Answer 1

Hi @S G ,
The "Add Total" command is context-sensitive and only supports numeric fields. You can refer to: Add totals to a group or Tablix data area (Report Builder and SSRS)
I did some tests as follows.

Then I click on the "Salary" option to add the total.This operation can be successfully performed.

This is the sum of the grouping "Hire Date". The preview effect is as follows.

Right click on the "Sun(Salary)" option to add the total.This is the sum of the grouping "Department Name".

In the end we will get the result as shown below.

Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Joy,
Thank you very much for your help. I tried to follow your suggestion and noticed when I right click on the column to find the 'Add total' option, it was grayed out. I check the data type for the salary and to my surprise it had changed to nvarchar(50). This must have happened when I created the dbo.EMPLOYEES table from a corresponding table in an Oracle database. Anyway, all is good.

Thank you very much!