Search code examples
reporting-servicesssrs-2008ssrs-tablix

How to display more than one value as separate row in matrix column grouping in SSRS

I am facing trouble displaying multiple result set in rows in matrix column grouping.

My Data set -

enter image description here

My desire result set -

enter image description here

My design -

I did row grouping combination of Code and Tax, column grouping on Exam.

enter image description here

Based on my design, I get this result -

enter image description here

Is there a way that I can get desired result?

I would appreciate if someone helps me.

Solution

  • I would love to solve this in the comment itself but i do not have enough reputation to comment. So based on the provided data in the question below is my answer.

    In your data set add another column for the grouping the data. Add DENSE_RANK() over (partition by exam order by item) AS Grouping and then change your row grouping to the new column added [Grouping]

    enter image description here enter image description here

    enter image description here