Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: Running totals in detail line

    I have a problem.

    I am working on a report that list orders and material requirements. The report breaks by part number.
    For each part number there can be multiple orders. One of the fields in my reports links to the inventory database. This database lists the part number and the current balance remaining.

    In the report, I may have multiple order numbers for a particular part. The field headings and data should look something like this:
    Code:
    +-------------+---------+---------+------------+----------+---------+
    | Part number | Beg Bal | Order # | Order date | Curr Req | Balance |
    +-------------+---------+---------+------------+----------+---------+
    |        123  |   1,000 |         |            |          |         |
    |             |         | 12345   | 1/1/2007   |     100  |  900    |
    |             |         | 23456   | 2/1/2007   |     150  |  750    |
    |             |         | 45678   | 3/1/2007   |     100  |  650    |
    |        257  |     600 |         |            |          |         |
    |             |         | 32345   | 1/1/2007   |     200  |  400    |
    |             |         | 44456   | 5/1/2007   |     300  |  100    |
    |             |         | 55678   | 6/1/2007   |     400  | -300    |
    +-------------+---------+---------+------------+----------+---------+
    This is how it should look. I am having a problem creating a running sum for the transaction details. Do you have any ideas on this. A variation on this report would be to produce a sub-report that list only those orders that result in a negative balance - but that is for another day.
    Last edited by gvee; 09-12-07 at 15:28. Reason: Re-formatted table.

  2. #2
    Join Date
    Jan 2007
    Posts
    5
    Please edit your post and use punctuation between the field headings so we can tell how many fields you have.

    Also put your data inside the code tags to make sure that you can get the layout of the data to line up in the correct rows.

    Make these changes and it will make it easier for us to help you.

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    Thanks. I did not know how to do that.

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Add another Curr Req field to your report. Change the property Running Sum in the Data tab to Over Group. Then name the field txtDollars and set Visible = False.

    Now add a field (a text box that is unbound) for the Balance and set the source to =Total-txtDollars. This should give you the results you want.

Posting Permissions

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