Hi All,
I need to show sum of group running total in report footer.
I need to calculate when disporder is 1 or 2 only.
I created formula like this.
numbervar cftot;
numbervar gcftot;
if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then
cftot:=cftot+sum({Payments.totsales},{Payments.pm_desc});
if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then
gcftot:=gcftot+cftot;
if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then
cftot;
Here the sum of all groups which is for disp order 1 or 2 is 12938.This I need to show in report footer.
But in report footer I am not getting 12938.
Please help
PFA
Hi Divya,
Change the formula to:
whileprintingrecords;
numbervar cftot;
numbervar gcftot;
if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then
(
cftot:=cftot+sum({Payments.totsales},{Payments.pm_desc});
gcftot:=gcftot+cftot;
cftot;
);
Create a reset formula and place this on the Group Header:
whileprintingrecords;
numbervar cftot := 0;
Create another formula and place this on the Report Footer:
whileprintingrecords;
numbervar gcftot;
-Abhilash
Add a comment