Re : Report look like matrix [message #89965] |
Fri, 17 September 2004 22:54 |
jhsharma
Messages: 58 Registered: June 2004
|
Member |
|
|
I want to make a report which should look like matrix report but a different idea
format for that report looks like
value for the column would be from one single column while the row should be form the different col. of the table. eg.
structure of the table
table t1
a1
a2
a3
table t2
t1 (has data as a1)
t2
t3
t4
my report looks like
columns from a1.1 a1.2 a1.3
text1 sum(a2).................
text2 avg t3
text3 avg t3
.............
..............
can any body guide me
using oracle 8 and d2k
thanx and regards
|
|
|