Re: Multi rows and colums reports

In <3r0sdt$sna_at_ankh.iia.org> jstarwoo_at_haven.ios.com (Jim Starwood) writes:
>
>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.

Why even bother with an ASCII file? Excel will let you get the data directly through ODBC using their integrated MS-Query tool.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!