Forum Discussion
Hierarchy in Report Builder
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?
2 Replies
Hi abhijsrwalahoon ,
Create a recursive hierarchy group
-
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.
-
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.
-
In Group expressions, select Add. A new row appears in the grid.
-
In the Group on list, type or select the field to group.
-
Select Advanced.
-
In the Recursive Parent list, enter or select the field to group on.
-
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
-
