Summing on value in group footer
Hi
I have created a report that shows the client name and their code in the
group header, their transactions in the detail band, and their last balance
in the group footer band. I would like to sum the balances that occur in the
footer band only ( not all balances as these occur at the time of each
transaction )
I am using Delphi 7 Pro and RBuilder 7.02 Enterprise and DBISAM ver 3.21
I would very much appreciate a solution to my problem.
Thank you.
Allan.
I have created a report that shows the client name and their code in the
group header, their transactions in the detail band, and their last balance
in the group footer band. I would like to sum the balances that occur in the
footer band only ( not all balances as these occur at the time of each
transaction )
I am using Delphi 7 Pro and RBuilder 7.02 Enterprise and DBISAM ver 3.21
I would very much appreciate a solution to my problem.
Thank you.
Allan.
This discussion has been closed.
Comments
Try placing a TppVariable in the group footer and in its OnCalc event,
update another TppVariable in the location of your choice with the sum of
all the values in the footer.
TForm1.ppVariable1OnCalc(Sender: TObject; var Value: Variant);
begin
ppVariable2.Value := ppVariable2.Value + Report.DataPipeline['DataField'];
end;
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com