conditional suppress at Group level

[LenaS]

I have added

Sum({ledger.osloss},{ledger.claim})=0 and Sum({ledger.osexp}, {ledger.claim})=0

to the Group footer #4:ledger.claim suppress formula. This took it down about 300 pages but still I have some occurrences of osloss and osexp both equaling zero printing on the report.

 

[synapsevampire]

Perhaps the issue is that one or the other is not zero, rather they are null?

Try selecting Report->Report Options->Convert null field value to default

Providing you're not using null to detect anything.

-k

 

[LenaS]

Makes no difference. The fields in question do not accept null values. Also tried Convert null field value to default. Thought that maybe it might be a decimal problem like 0.00000005 but that is not the case either the fields are currency

 

[LenaS]

Okay if you put

Sum({ledger.osloss},{ledger.claim})<>0 and Sum({ledger.osexp}, {ledger.claim})<>0

in the group selection formula it seems to work fine.
Thanks for your input