DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: table design????Urgent

  1. #1
    Join Date
    Nov 2000
    Posts
    198
    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]

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    198
    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..

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width