I am trying to create a report that outputs a single row per student with a column for each of their classes. The obvious way is via a Matrix, however I am struggling with the setting for the Column Group - I need the output to run like the below:
The data is a row per Student and Group, as below:
so what I want is basically a Matrix with the Column Grouping set to something like ="Group" & CStr(RowNumber("RowGroup"))
Unfortunately SSRS won't let me do that because the RowGroup does not contain the column group. So how can I otherwise achieve this? I guess I can do a vb hashtable in Custom Code, but that's pretty annoying and feels really clunky so I'd rather a better solution.