0
votes

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.stack.imgur.com/mVRhM.jpg https://i.stack.imgur.com/mVRhM.jpg

1

1 Answers

1
votes
  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