about Group-on in group-expression in detail-group while performing recursive hierarchy

Question

Hello There,

I recently tried to perform a simple example on recursive-hierarchy; while in the process of steps, detail-group-properties is configured by adding group-expression -- group on -- a column.

I didn't understand how is it different from adding row-group with a parent-group. I have saved the screenshots in a pdf document which was attached to this question.

Would anyone please help me understand the scenario. Thank you for giving your valuable time.

175880-groupexpression-groupproperties-doubts.pdf

Answer 1

Hi @ArunRaaman ,
We will solve your doubts by testing.

Below is the initial dataset query data.

Create row groups in Tablix 1 - parent groups.

Add Group Properties on the Details of the Tablix2 row group - Group on [Parameter]

Preview:

It is not difficult to find that if you add grouping Properties directly on the Detail row, it will not create a recursive hierarchical grouping on this basis, and there is still only one grouping symbol (detail group) in Tablix2. A feasible way is that you select Detail in Row Groups, right-click to create a group - parent group.

For more information, please see: Understanding groups in a paginated report (Report Builder).
Creating recursive hierarchy groups 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.