Reporting Services (SSRS) Part 6 - Grouping in Tables
Why Stack Overflow recommends it
Stack Overflow users link it when someone asking about SSRS reports needs to group rows, add a parent group, or produce totals and subtotals.
Recommended by 3 people across 3 different months, 2017 to 2020.
What it is
A 21-minute SSRS (SQL Server Reporting Services) tutorial from Wise Owl Tutorials, presented by Andrew Gould. It shows how to add parent groups to a report table, apply subtotals to numeric fields, and build collapsible groups that users can expand or hide.
What people said
Recommends Jesse · 2017-06 · Stack Overflow · on “Trying to keep data from moving down in grouped report”
It looks like you need to add a parent group by company first. Then you are headed down the right path. I would Google that but here is a great video that helps... [this video]
Recommends AnkUser · 2018-10 · Stack Overflow · on “SQL Query to Build SRRS Dynamics 365 Report”
If you are using Dynamics 365, You should be using FetchXMl quires and not sql for developing Reports. Here is the Video tutorial Link [LINK] for Creating SSRS Reports. Now let's Lead you close to achive your solution. Create a Fetchxml query where you link your Table 1 and Table 1 based on Section (and join type should be Inner) In Visual Studio Data tools for SSRS you will find lot's of different ways to represent/manipulate your Data. To achieve Output 1 you could Group the Rows by Section and IT will appear only single row per Group. Here [this video] is one more simple tutorial for grouping.
Recommends Benzi · 2020-02 · Stack Overflow · on “SSRS REPORT for summary and individual”
I am not sure that I understood your question, but you can use group, totals and page brake to achieve "display all the individual use". [this video]