| Problem regarding Matrix Report in Developer 2000 [message #132151] |
Thu, 11 August 2005 02:09 |
RajivSky
Messages: 1
Registered: August 2005
|
Junior Member |
|
|
Hello there,
Thank you for reading my post.
I have a problem regarding matrix report in D2K and Oracle 8i.
I need a report, the report's 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;
-----------------------------------------------------------------
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 | |
-----------------------------------------------------------------
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 I have to user formula Column)
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 just the soon as you can.
Thank you in advance.
RajivSky
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
