I'm using Jasper Reports/iReports crosstabs to create a matrix of student and results.

So for example Jim is doing subjects A, B, C and Sally is doing A, C

What I want is something like:

    Subj-A   Subj-B   Subj-C

Jim P M D Sally D D

But as my SQL orders by name then subject I get:

    Subj-A   Subj-B   Subj-C   Subj-A   Subj-C

Jim P M D
Sally D D

As you can see in the above the results are correct but the formatting is woeful. Is there anyway I can generate the reports to use names and subject only once and filling in the values from here?

This probably isn't clear.