Hierarchy in Report Builder

[abhijsrwalahoon]

Hi All,

I need to create a hierarchy in Report builder like this:

I have been looking into the documentations on online videos around that in SSRS and Report builder to do this. But I get just one element from per child hierarchy.

My SSRS/Report builder output looks like:

What am I missing?

[Anonymous]

Hi  @abhijsrwalahoon  ,

Create a recursive hierarchy group

1. In Design view, add a table, and drag the dataset fields to display. Typically, the field that you want to show as a hierarchy is in the first column.

2. Right-click anywhere in the table to select it. The Grouping pane displays the details group for the selected table. In the Row Groups pane, right-click Details, and then select Edit Group. The Group Properties dialog box opens.

3. In Group expressions, select Add. A new row appears in the grid.

4. In the Group on list, type or select the field to group.

5. Select Advanced.

6. In the Recursive Parent list, enter or select the field to group on.

7. Select OK.

   Run the report. The report displays the recursive hierarchy group, although there is no indent to show the hierarchy.

More details: 

Create a recursive hierarchy group in a Power BI paginated report - Power BI | Microsoft Learn

Create recursive hierarchy groups in a paginated report - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abhijsrwalahoon]

I have been doing that, the problem is, my parent and child fields are different columns. your work like when employee and managers are in same column