Joe Yoder wrote on 2016-08-23:

> I have a report that amounts to simply printing each record from a table.

> There is no subgrouping of the data. All that is needed is a grand total

> at the bottom. How does one setup the report writer to get and print the

> total?

>

> TIA - Joe

>

Joe,

Under the Reports, menu, select Optional Bands.

In the Report Properties window on the Optional Bands tab you'll want to

check Report has summary band.

Then click over to Variables, I create variables with the m. notation. So I

add m.summary

Value to store is the field you want to sum.

Initial value is 0

Reset value based on is report

Calculation type is Sum

Then you add a textbox to the Summary band (the names are at the bottom of

the band) and put in m.summary. (or the variable name you used)

Tracy Pearson

PowerChurch Software

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/002101d1fd4d$29c795b0$7d56c110$@powerchurch.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.