A simpler way to do that, without using any variables is thus:
Copy the control you use to display each record in the summary band, but set the calculation type to sum
At the end of the report this control will show the sum of the records, as requested
Rafael Copquin
On 23/08/2016 11:46, Tracy Pearson wrote:
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
[excessive quoting removed by server]