Determine Field = 0 and "Null" Field

[fort]

I am using Windows 2000 and Crystal Reports 8. I have been trying to determine a field which is either null or a field = 0. I have tried (IsNull{Field} or {Field} = 0. Any suggestions??

Thanks!!

 

[dgillz]

Try the following:

IsNull({Fieldname}) or
length(trim({Fieldname}))=0 or
{Fieldname}=0

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[fort]

I failed to mention this for a currency field. I tried it stating--

If (IsNull({Field} or ({Field} = 0)) then..

Any more ideas??
Thanks!!

 

[elead]

Thanks

 

[dgillz]

Did you try my syntax?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[lyanch]

Your parenthesis are in the wrong place. It needs to be:

IsNull({field}) or {field} = 0

 

[synapsevampire]

Use File->Report Options and select convert Null Field Value to Default, then you don't have to check for null, just 0.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com