SSRS 2008 - Tablix Grouping

Lets assume our source table is like below image

Step: 1

1.Add the same dataset to your SSRS Report , Right click on the dataset folder- choose datasource etc,,

2.Then you dataset will appear like below image

Step :2

1.Add table to your report and assign your dataset to that table in the property

Step: 3

1.Assign the column field in the dataset.
2.As for this solution Add 'Mark' and 'Subject' field alone
3.Remove other empty columns

Step: 3
1.Right click of the row header of the row (not the row header of the column) and click on the 'add Group ' the 'Parent Group' below screen will appear

2.Select the 'Subject' field and click group header check box(This will add one row for group header)
3.Press ok

You can see group below as marked below

Step: 4
1.Repeat the step 3 and add group for 'Exam' and 'Name' field so you can see as below

Step: 5
1.Now if you run your report you can see the grouping like below image

Now add toggle to the group
1.click on the corner of 'Subject' group (Below Row groups) appears below the rdl page
2.Click on visibility field
3.Click on the hide radio button
4.Click on the 'Display can be toggle ' check box
5.Select Exams group in it.
6.Click ok

Step :6
1.Now repeat the step 5 for 'Exam' group
2.Select the toggle as 'Name' group
3.Remove the Normal Subject column
4.Make the header as bold and any other design you want
5.Run you report it will look like below