Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146

    Exclamation Unanswered: Running sum in Report adding detail twice

    I have a report that is adding the last detail in the detail section twice when calculating a running sum. My report is setup as follows:

    Report Header:
    Page Header:
    FirstName Header:

    ClassifiedNo Header:

    Detail Section: (Subtotal box)
    [Text280] = NZ([Text247])+NZ([Text151])+NZ([Text281])
    (Where [Text247] is a product total, [Text151] is an addition charge total, and [Text281] is interest acrused to that date)

    ClassifiedNo Footer (Sum box)
    [Text122] = [Text280] (Running Sum set to "Over Group")

    FirstName Footer: (Grand total box)
    [Text305] = [Text122]

    Page Footer:
    Report Footer:

    The goal is to have the subtotals of each detail summed in the FirstName group footer. The problem is that it works, but it adds the last detail twice as in the following example:

    http://images5.theimagehosting.com/ReportProblem.1.gif

    The subtotals $16.00 + $18.00 should equal $34.00 in the footer, but they don't. Instead, the last detail ($18.00) is added again (therefore, twice) and gives me a total of $52.00 in the footer. What gives? Many thanks in advance for any suggestions.
    Attached Thumbnails Attached Thumbnails ReportProblem.gif  

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    Hi
    Is it possible for you to post your database ?
    Chris

  3. #3
    Join Date
    Dec 2004
    Posts
    15
    Quote Originally Posted by howey
    Hi
    Is it possible for you to post your database ?
    Chris

    HI
    ITS THIS A DB FILE FOR A STORE OR VIDEO STORE?

    CAN YOU SEND ME A COPY?
    THANKS

Posting Permissions

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