I have a problem regarding matrix report in D2K and Oracle 8i.
I need a report, the reports general format is like;
------------------------------------------------------------------------|
Trans_type:| P (Produciton) |
------------------------------------------------------------------------|
| Capacity |
|---------------------------------------------------------------|
Cyl_Type| 3.11 |5.1 |8.1 |9.5 |11.2 |Liter |Cub M. |
--------|---------------------------------------------------------------|
H2o | 5 | |2 | |3 | | |
c2 | 5 | | | | | | |
co2 | 4 |2 | |5 | | | |
Mox | 5 |5 |9 |10 | | | |
L2o | | | | | |20 | |
------------------------------------------------------------------------|
Total | 19 |7 |11 |15 |3 |20 | | |
------------------------------------------------------------------------|

Using matrix report in D2k I have generated the format like follwing.
for this I have to use 4 tables get the desired format;
I am not able to generate the Cub.M. field using the matrix report(with group option) for that I have to use the formula column.
(Can I generate the Cub. M filed as needed using Matrix report? or normal query report or I have to user formula Column)
-----------------------------------------------------------------
Trans_type:| P (Produciton)
-----------------------------------------------------------------
| Capacity
|--------------------------------------------------------
Cyl_Type| 3.11 |5.1 |8.1 |9.5 |11.2 |Liter |
--------|--------------------------------------------------------
H2o | 5 | |2 | |3 | |
c2 | 7 | | | | | |
co2 | 4 |2 | |5 | | |
Mox | 5 |5 |9 |10 | | |
L2o | | | | | |20 |
-----------------------------------------------------------------
Total | 19 |7 |11 |15 |3 |20 | |
-----------------------------------------------------------------

Now ,in Cub.M what I need is the total row wise sum of (Capacity*Cyl_Type)
for example: in Cub.M. for H2o I need : 65.35
i.e.
(3.11*5)= 15.55
(8.1*2)= 16.2 +
(11.2*3)= 33.6 +
--------
65.35

for C2 I need: 21.77
i.e.
(3.11*7)= 21.77

and so on...

Now, the problem is how can I Refernce the Individual column of Matrix Report
to use in formula column to calculate Cubic Meter for Cub.M. Column.

I wonder if you could plese help me regarding this matter.

Thank you in advance.
RajivSky