Search code examples
reporting-servicesssrs-2008

Group Total after each group in SSRS

I have a requirement to display the records in groups (based on 2 columns - Partner & Type) along with group totals after each group and finally a grand total. Attached image has the required output also attached how it is coming up now in SSRS 2008. https://i.sstatic.net/mVRhM.jpg https://i.sstatic.net/mVRhM.jpg

Solution

    1. Initially create a table with two columns with a group on partner. The table has 4 rows: one for headers, two for the partner group and one as footer (like the border layout).

    2. Create a table with your column names and drag it on the header cell

    3. Create a table with row detail data and drag it on partner group first row

    4. create a table with data grouped on type and drag it on partner group second row

    5. create a table with data grouped on type(clone the previous) and drag it on the footer total cell

    enter image description here

    Your final result should look like the image below

    enter image description here

    Running the report:

    enter image description here