locked
Column totals for report RRS feed

  • Question

  • Hey everyone,

    I'm creating a report and need the totals of a column in a table but I can't figure the code to get the total of the column. I'm sure its very simple, I'm just having a heck of a time with it.

    Thanks in advance,
    Kadrin
    Wednesday, June 27, 2007 2:49 PM

Answers

  • Select sum from calculations, do not type sum().

     

    To be more clear:

     

    -Copy and paste a copy of your field to group footer

    -DblClick it

    -In calculate tab select sum (and when to reset - probably you want it to reset per your grouping)

    Wednesday, June 27, 2007 3:39 PM

All replies

  • Create a summary band (Report\Title\Summary). Then add your numeric fields there (just copy them from the detail band).  Double Cick on the field to go to properties, select Calculations and then Select Sum.

     

    This should be it, now you have totals in the summary band. Don't forget to chek reset at the end of the report.

     

    Wednesday, June 27, 2007 3:08 PM
  • Hm, I am trying to get it to print in a group footer. But when I do as you said it says "sum.prg does not exist."
    Wednesday, June 27, 2007 3:28 PM
  • Select sum from calculations, do not type sum().

     

    To be more clear:

     

    -Copy and paste a copy of your field to group footer

    -DblClick it

    -In calculate tab select sum (and when to reset - probably you want it to reset per your grouping)

    Wednesday, June 27, 2007 3:39 PM
  • Ok I understand now. I was clicking the ... box to do it before. Thank you.
    Wednesday, June 27, 2007 3:47 PM
  • Yea I found that part as well haha, for resetting it that is.
    Wednesday, June 27, 2007 3:56 PM