hi all i do have a problem on hierarchical sum on crystal report.

I have a report in which i have done hierarchical sum, and grouping everything works fine. But the problem is, i have 4 levels of reporting in which data is only in 4th level, i have to supress all the lines if every column of that row contains 0 value for eg:

S.No Account Name Level Amount1 Amount2 Amount3   Comment
1       L1Account            1         0              0              0   
2        L1Account           2         0              0              0
3         L1Account          3         0              0              0           Supress this row
4          L1Account         4         0              0              0           Suprress this row

i have supress the line 4 by using the formula as below:
if (
Sum ({command.Amount1 }, {command.Segment_0})=0
and Sum ({command.Amount2 }, {command.Segment_0})=0
and Sum ({command.Amount3 }, {command.Segment_0})=0 ) then true;

but Cannot do supress with same formula , when i use this formula each and every 3rd level get supressed even if it has value like below:


S.No Account Name Level Amount1 Amount2 Amount3   Comment
1       L1Account            1         0              0              0   
2        L1Account           2         0              0              0
3         L1Account          3         0              300          0           Supressed
4          L1Account         4         0              300          0           Not Supressed