How to Get Records to Display in the way I need

Question

All,

I have a result set with a parent "YourName" record and parent "module_viewed" records. I also have multiple child records, "modules_completed" per parent record. What I need is to be able to display in one horizontal row "YourName", "module_viewed", and then the several "modules_completed" records associated with each of these parent records.

I would like to know a good approach to achieving what I need. I've been trying to use an entity object I wrote, where I create a new instance of this object every time I hit a new "YourName" record. I haven't been able to get it though.

Below is an example of the result set I'm getting out of SQL Server. Any help would be greatly appreciated

Derek Kenney

*****************************************************************************************

YourName       Modules_Viewed    Modules_Completed

Derek Haines        1                 1
Derek JK                         1
                0                 2
                0                 3
                0                 4
                0                 5
                0                 6
                0                 7
                0                 8
                0                 9
                0                 10
                0                 11
Derek JK        2                 0
Derek JK        3                 0
Derek JK        4                 0
Derek JK        5                 0
Derek JK        6                 0
Derek JK        7                 0
Derek JK        8                 0
Derek JK        9                 0
Derek JK        10                 0
Derek JK        11                 0