Hi ,
I‘m working for suppressing the group footer values when all the Calculated in Number (1,2,3 & Over 3) are Zero.
I’m using the below condition for suppressing the group footer values.
If Sum({Command.No15_30}, {@@fa_no}) <> 0.00 OR isnull(Sum({Command.No15_30}, {@@fa_no})) Then
False
Else If Sum({Command.No45_61}, {@@fa_no})<> 0.00 OR isnull(Sum({Command.No45_61}, {@@fa_no}))Then
False
Else If Sum({Command.No75_91}, {@@fa_no})<> 0.00 OR isnull(Sum({Command.No75_91}, {@@fa_no}))Then
False
Else If Sum({Command.No_90}, {@@fa_no}) <> 0.00 OR isnull(Sum({Command.No_90}, {@@fa_no}))Then
False
//--Else If Sum({Command.No15_30}, {@@fa_no})+Sum({Command.No45_61}, {@@fa_no})+Sum({Command.No75_91}, {@@fa_no})+Sum({Command.No_90}, {@@fa_no})<> 0.00 Then
//--False
Else True
Calculated in Number
ONe two three over three total
$672.09 $0.00 $0.00 $0.00 $672.09
$56,468.77 $257.22 $0.00 $0.00 $56,725.99
$0.00 $0.00 $0.00 $0.00 $0.00
I’m encountering the problem while suppressing the group footer values when all the values are zero.
So try to test the conditions by adding one by one, I’m able to suppress the first 3 values for Calculated in Months (1,2,3).
I’m unable to suppress the values, while adding the 4th condition(Sum({Command.No_90},
{@@fa_no}) <> 0.00).
I would like to supress the 3rd row of data, Since all the vaules are zero.
Note:total is (sum of ONe+two+three+over three)
Pls Advice me.
Thanks.