Multi rows and colums reports

Dear World,

I am using Oracle Reports V2.0 and wish to produce a report such that both the number of rows and columns are not fixed. Example :

	Student 1	Student 2	Student 3 .........
History   xxx		xxx		xxx
Geography yyy		yyy		yyy
English   zzz		zzz		zzz

In this case, the number of subjects and name of students are not fixed, ie. the number of students and courses offered year by year can be different.

I was asked to use some sql construct to produce such a matrix layout onto an ASCII file (spool), and then download to Excel for final touching up. My table construct may look like :
Marks_Table(Subject, Student name, marks) ;

Thanks for any advice

Rgds
Loh Kir Chern
Email : mcblohkc_at_leonis.nus.sg Received on Tue Jun 06 1995 - 00:00:00 CEST