Summary band does not work for summing up the groups totals
I got group band (group header and footers), it works well.
However, I want to sum up all the sub-totals of the groups by putting a
TppDBCalc on the summary band, but it did not work.
The TppDBCalc only shows the value of the last group subtotal but not the
grand total.
eg.
Group footer TppDBCalc sums up the total of salary of a group.
Summary TppDBCalc also sums up the same field. I assume it should sum up the
'ALL' sub-totals of all the groups.
Anything I missed?
However, I want to sum up all the sub-totals of the groups by putting a
TppDBCalc on the summary band, but it did not work.
The TppDBCalc only shows the value of the last group subtotal but not the
grand total.
eg.
Group footer TppDBCalc sums up the total of salary of a group.
Summary TppDBCalc also sums up the same field. I assume it should sum up the
'ALL' sub-totals of all the groups.
Anything I missed?
This discussion has been closed.
Comments
http://www.digital-metaphors.com/rbWii/Delphi_Code/Calculations/SummaryCalc_OnGroup_Totals
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Be sure the dbCalc component in your summary band does not have a reset
group. Otherwise it will reset its value each time the group breaks.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I figure out the problem by finding the 'ResetGroup' property of the group
detail band pointing to the wrong group.