Re: Multi rows and colums reports
Date: 1995/06/06
Message-ID: <3r0sdt$sna_at_ankh.iia.org>#1/1
Loh Kir Chern (mcblohkc_at_leonis.nus.sg) wrote:
: 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
: 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.
: onto an ASCII file (spool), and then download to Excel for final touching
: up. My table construct may look like :
At the risk of being deemed an SQL wimp, My solution is to drop the straight into the ASCII file and use the cross tab feature in Excel 5.
It's not worth bothering with manipulation if the total result set falls under 16K rows.
Jim Starwood I like a chromatic love affair... jstarwoo_at_haven.ios.com one half-step at a time.Received on Tue Jun 06 1995 - 00:00:00 CEST