I have a report where a student should have multiple rows if they are receiving multiple degrees.
Here are the results from my SQL. The query designer returns this as well, so I know the correct data is going into the report.

I should see the MA records for each of these people as well. It is not hiding all MA records. I tested this just now with other people. It appears to only choose one when a person has a record with each value.

The bracketed section is all included in the StudentLevelGroup. The top row of it seems to be where the problem is. Everything else is working correctly. I have double checked there no filters on the tablix or any of the groups. The only visibility expressions are on those bottom sections that are not shown in the results. HideDuplicates in the properties is also empty for each of these rows.
Is there anything else I could check?



