please help with grouping details and totals

Question

I am trying to get the same layout going in ssrs as in the picture below.
Bascially there is a parent group on business area/line and then it groups on event type too and does the totals on the top line. right underneth the totals for the event type it goes into the detail to list each one of those events that make up the total on the line above. How can i achieve this in SSRS?

Answer 1

Hi @Evghenii Luchianic ,
If you want to display the total number of information at the top of the report, and the detailed information row at the bottom half, you could consider using the form of subreports or nested data regions. For more information, please refer to: Subreports in paginated reports (Report Builder), Nested data regions in a paginated report (Report Builder).
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.