Nested Groups Using One DataSource

[nrange]

Hello,

Hoping someone can point me in the right direction. Below is a subset of the data I'm working with. This data is pulled into the report using a single data source.

Id Name DomainPartitionId TargetStartDate TargetFinishDate
2065665 Project 1 0 NULL NULL
2065678 Project 2 0 NULL NULL
5105501 Project 3 0 2020-05-18 2020-08-25
5105521 Project 3 Sub Project 1 5105501 2020-05-18 2020-05-21
5105541 Project Sub Project 1 Sub Project 1 5105521 2020-05-18 2020-05-18
5105561 Project Sub Project 1 Sub Project 2 5105521 2020-05-19 2020-05-21
5105562 Project 2 Sub Project 1 2065678 2020-05-19 2020-05-21
5105563 Project 2 Sub Project 1 Sub Project 1 5105562 2020-05-19 2020-05-21


In this data set the DomainPartitionId identifies the parent project Id. I'm attempting to display the data like below in the report using Group Headers/Footers (Note, the hierarchy with the complete dataset goes much further than 2 levels deep):

Name TargetStartDate TargetFinishDate
Project 1
Project 2
Project 2 Sub Project 1 2020-05-19 2020-05-21
Project 2 Sub Project 1 Sub Project 1 2020-05-19 2020-05-21
Project 3 2020-05-18 2020-08-25
Project 3 Sub Project 1 2020-05-18 2020-05-21
Project Sub Project 1 Sub Project 1 2020-05-18 2020-05-18
Project Sub Project 1 Sub Project 2 2020-05-19 2020-05-21

I'm having an extremely hard time doing this with the documentation that is available and have been banging my head against the wall for the past couple days. Any guidance would greatly appreciated.

Thanks in advance for your time!

[HighAley]

Hello.

Please, try to look at the Hierarchical Band.
https://www.stimulsoft.com/en/documenta ... l_band.htm

Thank you.

[nrange]

Thank you HighAley! I will give this a shot.

[HighAley]

Hello,

We are always glad to help you.
Let us know if you need additional help.

Thank you.