Difference between Grouping and Adjacent grouping in ssrs

Navinkumar Kanagaraj 86 Reputation points

In SSRS, I feel like grouping and Adjacent grouping does the same wrk. Still, I have gone through some videos and webpages, I feel the same. Can anyone please give me a proper difference that makes grouping and Adjacent grouping differ?

MY UNDERSTANDING: Grouping gives out dependent details or summary of data, Whereas Adjacent Grouping gives out summary without dependencies.

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.
2,860 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points

    Hi @Navinkumar Kanagaraj

    As far as I known,Adjacent group is group too. The only difference is that the term adjacent group is based on the group you previously created. It means the two groups are independent of each other, not an inclusive relationship. You can delete a previously created group without affecting this current group.
    If you still confused of it,please feel free to contact me.

    Best Regards,

    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.