Hello all,
I need some matrix query as follows, I have table with three columns as c_name, month, po_no. I want to generate a report which looks as followos.
C_NAME JAN FEB MAR APR .........
-----------------------------------------------------------------------
jkinfotech 30 0 6 61 ..........
softtech 6 30 29 11 ..........
allsoft 76 23 81 8 ..........
where the numbers are po_no.
Can any one help me.
Nilopher.