Results 1 to 7 of 7
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: I dont know why Calculation Doesnt Work in Report? Can anyone help please?

    I have got a report which is supposed to give me the total of "Amounts" field which is in the "Details" section of the page.
    I have created a text box in the Page Footer of the page and put this formula =Sum([InterpreterTotal]) but unfortunately it doesnt work and it give me error.

    I tried putting the formula text box in the employees footer section of the report and it worked BUT it separates total for each employee and I want the total for all employees.

    Any help would be gratefully appreciated.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Can you put the report in a smal sample and attach here?

    I think I have a simple solution for you

    G

  3. #3
    Join Date
    May 2006
    Posts
    386
    Hi Garethfx,

    Here is the report. Thanks for your time and help.
    Attached Thumbnails Attached Thumbnails report.JPG  
    Emi-UK
    Love begets Love, Help Begets Help

  4. #4
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    You need the text box that is adding all amounts so that you get the total of all employees in the REPORT FOOTER under the page footer.

    If you want to total by employee then place a text box in the DETAIL section and sum amount there. you could then even work out what the % is of the total amount found in the report footer

    that help?

    Gareth

  5. #5
    Join Date
    May 2006
    Posts
    386
    Thanks for replying. I dont know to add total by employee, I want total by all. So how can I do that? and the text box for total of each employee against each record is there at the top of the report which is called "ClientAmountLessVAT".
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    have alook at the report 2 in here

    tell me how you get on

    Ive tried to add the 2 ways of reporting for you
    Attached Files Attached Files

  7. #7
    Join Date
    May 2006
    Posts
    386
    Hi Garethfx,
    Thank you every so much for your help. It worked perfectly all right.

    Thanks again.
    Have nice day.
    Emi-UK
    Love begets Love, Help Begets Help

Posting Permissions

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