URGENT HELP: Supress A Zero Value

[cgordonn]

Hi gang,
Having a bit of a problem with the suppression of zero values oin CR 8.5.

I have the following 3 fields in my detail...
{@DISBURSEMENTS}
{@RECEIPTS}
{@AMOUNTDUE} (this formula is {@Disbursement}-{@Receipts})

I have subtotals for these 3 fields in my group header, and have the details section supppressed. My goal is to suppress the group header if the subtotal of {@AMOUNTDUE}is zero. I dont want any group records that have an {@AMOUNTDUE} of zero to be on the report. This is what I have placed in the suppress X-2 of the format group header section...

Sum ({@Amount Due}, {AGPF400.TFFileNum})=0.00

The {AGPF400.TFFileNum} field above is my group. This seems to be working for some of the grouping records, but not all. It seems there are some zero values that will not suppress not matter what I do. I seems these zero values are not even zero values. I am stuck and need help. I do have the check box for NULL values in the report options checked off.

Any ideas?
Thanks!
CGordonn

 

[dgillz]

Yes, create a group selection formula by clicking on report, edit selection formula, group, then enter the following:

round(Sum ({@Amount Due}, {AGPF400.TFFileNum}),2)<>0

The round() function will help as sometimes there are very small values on the report such as 0.0000000012 instead of zero. You may have seen the same behavior in excel sometimes.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[cgordonn]

Thanks DGILLZ, that seemed to have done the trick.

CGordonn