| Reports 6i-Matrix Reports [message #89376] |
Tue, 02 March 2004 10:12 |
denni50
Messages: 18
Registered: November 2002
|
Junior Member |
|
|
Hello
we are in the process of developing in-house reports
that were previously outsourced with software vendor.
These Reports...for want of a better name...are called
Step Matrix Reports.
The following data is a sample representation of the data
that is considered part of the Matrice Design.
*************************************************
BEGIN
CASE amt
WHEN (BETWEEN .01 and 9.99) THEN AmtRange :=1;
WHEN (BETWEEN 10 and 19.99) THEN AmtRange :=2;
WHEN (BETWEEN 20 and 29.99) THEN AmtRange :=3;
WHEN (BETWEEN 30 and 39.99) THEN AmtRange :=4;
WHEN (BETWEEN 40 and 49.99) THEN AmtRange :=5;
WHEN (BETWEEN 50 and 59.99) THEN AmtRange :=6;
WHEN (BETWEEN 60 and 69.99) THEN AmtRange :=7;
WHEN (BETWEEN 70 and 79.99) THEN AmtRange :=8;
WHEN (BETWEEN 80 and 89.99) THEN AmtRange :=9;
WHEN (BETWEEN 90 and 99.99) THEN AmtRange :=10;
WHEN (BETWEEN 100 and 249.99)THEN AmtRange :=11;
WHEN (BETWEEN 250 and 999999.99)THEN AmtRange :=12;
ELSE AmtRange:=13; --if NULL
END CASE;
RETURN AmtRange;
END;
BEGIN
monDiff:= MONTHS_BETWEEN(dteComp,dte);
CASE monDiff
WHEN (BETWEEN 0 and 3) THEN DteRange :=1;
WHEN (BETWEEN 3 and 6) THEN DteRange :=2;
WHEN (BETWEEN 6 and 12) THEN DteRange :=3;
WHEN (BETWEEN 12 and 18) THEN DteRange :=4;
WHEN (BETWEEN 18 and 24) THEN DteRange :=5;
WHEN (BETWEEN 24 and 36) THEN DteRange :=6;
WHEN (BETWEEN 36 and 48) THEN DteRange :=7;
WHEN (BETWEEN 48 and 999999) THEN DteRange :=8;
ELSE DteRange:=9; --if NULL
END CASE;
RETURN DteRange;
END;
*************************************************
Calculations would be generated from formulas based on Amounts
given within a specified date range and number of contributors.
Is Oracle Reports 6i capable of producing these types of
Analysis Reports?
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
