SSRS how to add groups to a detail row
<p>I am re-writting this because I didn't communicate my problem correctly.</p>

<p>Given these sample tables of data:</p>

<p>STUDENT: Name, DOB, Council, ClassId</p>

<p>CLASS: ClassId, Teacher, StudentGradeId</p>

<p>GRADE: StudentId, ClassId, Grade</p>

<p>I have made a report that looks like this:</p>

<p><a href="https://i.stack.imgur.com/Pf7Au.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Pf7Au.jpg" alt="enter image description here"></a></p>

<p>But I need to hide the duplicate row details for Name, DOB &amp; Council.  I am currently grouping by StudentId which groups correctly, but I can't figure out how to get rid of the duplicate student data.  It should look like this:</p>

<p><a href="https://i.stack.imgur.com/F6TZO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F6TZO.jpg" alt="enter image description here"></a></p>