Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    77

    Unanswered: How to calculate an overall total for each report page and final total?

    Hi there

    I want to be able to generate an over all total for each page of my report and then a final total for the over all report.

    For the overall total for the page, I have tried using the running sum and I noticed that this carries the total for each line over and so on.

    Is there a way to just create an overall total at the end of each report page and then to generate a final total for the whole report?

    Any suggestions pls.

    Many Thanks for ur help in advance.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try to make instead of page sum Groupe Sum. Then make another text box to sum this Groupe's sum to get the total sum.

  3. #3
    Join Date
    Apr 2004
    Posts
    77

    re how to calculate report total on page

    Hi hammbakka

    Many Thanks for ur replies to my messages . Much appreciated.

    sorry what did u mean by groupe ?

    is this what u mean instaed of = sum(amountinpounds) this
    =groupe(amountinpounds)?


    Many Thanks for ur help.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    No, what I meant is make a new Group in the Report (a part as your Details one)
    then put a text box there, set its value to =1, and adjust its to property to be sum over all or sum over the group.

  5. #5
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    Sum your fields in Page footer and Report Footer to get the page totals and the final report totals

    - Saqib

  6. #6
    Join Date
    Apr 2004
    Posts
    77

    re total on report pages

    Many Thanks for ur reply.

    Summing total on page footer seems to give an error like this #error anytime I try to do this , however the report footer works fine.

    Many 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
  •