SSRS: Group Totals need to be displayed together

Question

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

Thanks in advance.

I'm showing you only an example of my report. The exact report has a lot of other data other than Book in the main table. — Tess, Dec 16 '14 at 17:57

score 1 · Accepted Answer · answered Dec 16 '14 at 18:12

1

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

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.

answered Dec 16 '14 at 18:12

Ian Preston

Thanks Ian. The idea of Adjacent Grouping helped. I got the exact results needed by adding the Adjacent Group State1 to State instead of details in the inner table. – Tess Dec 16 '14 at 18:20

1 Answers1