Microsoft Dynamics CRM (Archived)

SSRS report - Sum up multiple rows by grouping

(0) Share

Report

Posted on by Community Member

Hi All,

I am looking for some hints to sum of multiple rows and group by owner in SSRS report.

This is the original report I have

I would like to

1) Group the owner name together

2) sum up the number of cases acknowledged group by user as a new column

Any tricks to do it?

Please advice :) Thank you!!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Community Member on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

hi doll,

i m on the same situation as shown above.

if u solved it please guide me .

Was this reply helpful? Yes No
Suggested answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

Doll,

Sorry for late response

stackoverflow.com/.../vertical-merge-in-ssrs-tablix

To merge rows, you need to use the parent group.

Like you did for the CRM Admin 3 (Owner)

Btw, you did the grouping total right? So the first step done.

If the solution just to make 3 appearing once is okey to you, just hide one of the cell based on the Row Number or Running Number

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
RE: SSRS report - Sum up multiple rows by grouping

I add a parent group to "Owner" and child group to "Team",
and order the column as the below screen capture

Since tablix body must contain at least one column, I just made the last column invisible

Coding for the total column:

=Sum(Fields!ACKNOWLEDGED.Value,"Owner")

The report is now look like this:

The acknowledge number is sum up to the total column, but split into two rows with the same number, I would like to merge the cell....could it be possible?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
RE: SSRS report - Sum up multiple rows by grouping

I now create a group named owner,

and expression is

=sum(Fields!ACKNOWLEDGED.Value,"owner")

But I can only add the total column next to the owner group,

is it possible to move the total column to last row?

When I try to insert a column at the last column, there is no Outside Group to choose.

Please advice! Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
RE: SSRS report - Sum up multiple rows by grouping

Thanks for so many suggestion!!

This is how the query result look like:

I try with

=sum(Fields!ACKNOWLEDGED.Value,"Fields!FullName.Value")

or

=sum(Fields!ACKNOWLEDGED.Value,"FullName")

Both return error:

what should be the exact expression for the total column?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Abed Haniyah 4,287 on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

Hi Doll,

Please take a look to : www.youtube.com/watch

Regards,

Abed.

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

Doll Doll,

As long as you have the grouping id from the owner, you can achieve this by using SUM, using the scope of the group name

Example here:

=Sum(Fields!NumberofcaseValue,"OwnerGroupName")

Thanks.

Was this reply helpful? Yes No
Verified answer

Rajkumar Rajaraman on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

Hi Doll,

This is what the expression look like behind the Number of cases had been acknowledged by the user in total column:

=Number of cases had been acknowledged by the user in total(Fields!Number of cases had been acknowledged by the user,SUM,”Owner”)

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

RE: SSRS report - Sum up multiple rows by grouping

Hi Doll,

You can refer this blog:

www.codeproject.com/.../Using-SSRS-Matrix-Control-to-Generate-Columns-Dyna

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No