help with relationship and reporting data

[swf]

I have posted a sample file with students who take two different certifications A and B. Each students takes 4 tests for A and 4 tests for B. I want to be able to print out a report for certification A and certification B showing progress of each student. Ie. which student completed 1 or 2 or 3 tests. Students should only be in one category for each certification (ie the maximum test number). Report would be certification a, test 1 student names with total, test 2 student names with total etc. Then certification b , test 1 student names with total etc.

studentstest.fp7.zip

[comment]

Like this?

studentstest2.fp7.zip

[swf]

Exactly what I want. Even after reviewing your script I am unable to figure out how you removed the duplicates. ie john 3, john 2, john 1 to leave only john 3. I suspect it involves the # sign but I am not sure. An explanantion would be great. thanks

[comment]

It's a sub-summarized report, with no body part on the layout.