Page 1 of 1

Just need to make a simple total at bottom of report

Posted: Tue Oct 25, 2011 3:00 pm
by mcdonaldunit
I am banging my head against the wall trying to make this work.

Field is called "amount"

I need a summary of "amount" per person on each page of the report.

Why does sum(Qmf_temp.amount) return as invalid, and then crash my Powerchurch application when I try to preview the report?

Re: Just need to make a simple total at bottom of report

Posted: Tue Oct 25, 2011 6:40 pm
by Jeff
Just copy the amount field to the group footer or page footer band.

Double click it to open the properties for the field

Select the calculate tab and set the option to sum

Re: Just need to make a simple total at bottom of report

Posted: Wed Nov 02, 2011 12:02 pm
by mcdonaldunit
Thank you. It's so frustrating when you know something is very easy to do but you can't see how to get started doing it.