Reporting in VB 6

Sir,
My Project is for a college student management.It uses VB 6 and oracle at backend.
my problem is that i have 3 tables in oracle after combining those tables i got data in a mshflexgrid as follows for a particular register number;
subjcode subjname internals externals

cs201 data structures 12 67
…. …… … ..

now i want data in a new mshflexgrid or report in such a mannner

registerno cs1201 cs1202 cs1202 ……

i want to show the internals and externals of every subjcode such as cs1201 cs1202 in a new grid