I have a table with the following information

reg no name coursecode score
001 John com 111 50
001 john com 333 60
004 janet com 444 50
006 dave gns 111 20

............... . and so on and so forth.

I will like to create a report...