Kadrin


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



Re: Column totals for report

Naomi Nosonovsky


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.






Re: Column totals for report

Kadrin

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."





Re: Column totals for report

CetinBasoz

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)





Re: Column totals for report

Kadrin

Ok I understand now. I was clicking the ... box to do it before. Thank you.




Re: Column totals for report

Naomi Nosonovsky

Cetin explained it better than I did, though I meant exactly that Smile If you need it for groups, just do it in the group footer instead of summary and you would need to reset at the group expression.



Re: Column totals for report

Kadrin

Yea I found that part as well haha, for resetting it that is.