CODEWITHSUNDEEP
reporting-servicesssrs-tablixssrs-grouping
Tess
Tess

Reputation: 43

SSRS: Group Totals need to be displayed together

I've a report which is Grouped by Book ABC and then grouped by State to display the total of Qty.

enter image description here

Is it possible to display the Group totals all together at the bottom of the report ? Something like below: enter image description here

Here is my Report Design:

It is a table within a table. enter image description here enter image description here

Thanks in advance.

Upvotes: 2

Views: 63

Answers (1)

Ian Preston
Ian Preston

Reputation: 39586

I would do this with an Adjacent Group.

With data similar to yours (adding an extra Book):

enter image description here

I have a simple table, grouped by Book, which looks and acts like you'd expect:

enter image description here

enter image description here

Now, in the designer I will add an Adjacent Group, adjacent to the existing Details group, grouped on State:

enter image description here

Which looks like:

enter image description here

Now, within each Book I have two repeating groups, one that shows each detail row, then one that shows each State in that Book scope:

enter image description here

This seems pretty close to your requirement.

Upvotes: 1

Related Questions