question

NavinkumarKanagaraj-1813 avatar image
0 Votes"
NavinkumarKanagaraj-1813 asked IsabellaZhangMSFT-7746 commented

Difference between Grouping and Adjacent grouping in ssrs

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

194543-image.png




In the Image attached,you can see that in grouping based on region, then on year it is giving the amount whereas in adjacent grouping, it is giving out total amount year wise. But still this can be made in grouping also, right?

0 Votes 0 ·
image.png (160.4 KiB)

1 Answer

IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered IsabellaZhangMSFT-7746 commented

Hi @NavinkumarKanagaraj-1813

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,
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.



· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am sorry, I am still confused. Can you please provide me a clear explanation.

0 Votes 0 ·
IsabellaZhangMSFT-7746 avatar image IsabellaZhangMSFT-7746 NavinkumarKanagaraj-1813 ·

Hi @NavinkumarKanagaraj-1813
what makes you confused,I mean they are the same thing,no difference. Just a difference in creation time.When you add a matrix in page,there is a row group and column group , then you want to add another column group ,we can call it "Adjacent group".
Best Regards,
Isabella

0 Votes 0 ·

Hi @NavinkumarKanagaraj-1813
Are you still confused ?
we have not get a reply from you. Did any answers could help you?
If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

Best Regards,
Isabella

0 Votes 0 ·