Nested grouping vs Parent Child Grouping

Navinkumar Kanagaraj 96 Reputation points
2022-06-06T08:08:04.07+00:00

In SSRS, We can group by two types.

  1. By clicking add in the group properties.
    208674-image.png
  2. By Adding Child group under the previously created parent group.

Which will work efficient/Fast?
Note: There is no expr or total based on the Child group

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,646 Reputation points
    2022-06-06T09:42:35.417+00:00

    Hi @Navinkumar Kanagaraj ,
    I can't get your point clearly.
    Usually, we will use the method of adding parent groups/child groups to create groups. In this grouping method, you can clearly view row groups, column groups and details in the Grouping Pane. The Grouping pane supports two modes, which is convenient Subsequent design of the report (such as adding subtotals, fixing headers, etc.).
    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.

    0 comments No comments

  2. Isabellaz-1451 3,616 Reputation points
    2022-06-07T02:14:02.16+00:00

    Hi @Navinkumar Kanagaraj

    I did a local test ,you can take a reference.
    Preview result:
    208874-image.png

    My table is like this:

    208875-image.png

    Then I select the Details row group,set the properties like below:

    208876-image.png

    208964-image.png
    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and 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.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.