0

I am re-writting this because I didn't communicate my problem correctly.

Given these sample tables of data:

STUDENT: Name, DOB, Council, ClassId

CLASS: ClassId, Teacher, StudentGradeId

GRADE: StudentId, ClassId, Grade

I have made a report that looks like this:

enter image description here

But I need to hide the duplicate row details for Name, DOB & 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:

enter image description here

BattlFrog
  • 3,370
  • 8
  • 56
  • 86
  • 1
    You could using stored procedure to join 3 tables together, and only need one dataset. – Tony Dong Nov 15 '16 at 18:26
  • Assuming I have the query side figured out, is is possible to build this report? – BattlFrog Nov 15 '16 at 18:47
  • I would join the 3 tables into a single dataset, although the tables seem strange in their relationships. Once you have the dataset, create a matrix with Name, DOB, Council. Then add columns and a child group for classes, teacher, and grade. – Andrew O'Brien Nov 15 '16 at 18:49
  • Yes, like Andrew said, use matrix or table. I prefer table – Tony Dong Nov 15 '16 at 18:52
  • I haven't put my question across correctly. I have edited the OP, hopefully it communicates better. – BattlFrog Nov 15 '16 at 19:53
  • @BattlFrog, In that case you have to create a Row group for each field, Name, DOB, and Council. Go through the [official documentation](https://msdn.microsoft.com/en-us/library/ms170712.aspx). – alejandro zuleta Nov 15 '16 at 20:20
  • @alejandro zuleta, THanks, that was the trick. I was looking at it backwards, trying to group the child data. Thanks. You should post answer. – BattlFrog Nov 15 '16 at 22:17
  • @BattlFrog, you're welcome I posted an answer, you can mark it as the correct answer to close positively your question. – alejandro zuleta Nov 15 '16 at 22:23

1 Answers1

1

In order to avoid repeated rows in the Name, DOB, and Council columns you will have to create a Row group for each one. Go through the official documentation.

Let me know if this helped you.

alejandro zuleta
  • 13,962
  • 3
  • 28
  • 48