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]