-
Hi,
I need to create this Bill report on a monthly or weekly basis.
the report should look like this.
-----------FPN----amt_A---amt_B---total
-------------------------------------------
accum---X001----10-------20
Prev---------------5-------10
curr---------------5-------10--------15
this is the process needed to generate this report.
- the report is grouped by FPN
- line1 will have accumlatives up to the minute I am printing
this report.
- move line3 to line 2
- subtract line1 from line2 to get how much need to bill.
- repeat all the steps everytime the report is generated.
Any idea on how to design the tables, and the realtionships to do the job.
* I am using developer6 on oracle8.0.5 thanks in advance
[Edited by ocpdude on 12-08-2000 at 11:53 AM]
-
I think it is a query issue and not a design issue. This question would be better answered in the development forum rather than in the administration. If you could shed some more information on the columns and the table, I can try.
Sam
-
for the first line ...the record will be queried from a table
which has the data ( accum_amt_A, accum_amt_b);
the second line is the one I am having problem with!!
the first time I run this report line2 data will be all zeros...Then
I will get the current bill by subtracting line1 from line2.
Now I need to store the current bill record in a table so
that next time I run my report I need to move the current
record into line2 and do the subtraction all over again..
and so forth every time I run my report.
Hope that helps,
thanks in advance..
-
O.K I'm not much knowledge on the report generation side, but hope you could do the following.
create a transaction table. with 3 columns: two for the data and one for the flag.
now once afte you do a transaction, put the new values into the tansaction table. Then set the flag to be false. On the next time when you use that value reset the flage and insert a new value. One of the other things that you could add is a date column, such that you can hold a certain period of data and purge the reset (for maintanence reasons).
I hope this would help you to an extent.
Sam
