Skip to Content
0
Former Member
Apr 23, 2009 at 04:48 PM

Select formula -- retrieving record with null values

223 Views

I'm using Crystal 2008, v.12.

If I include this line in my report's selection criteria, it does not retrieve rows where the rate field being tested is null:

... not ({ACCT.Indirect_Cost_Rate_Percent} in [25.10, 28.60]) ...

If I remove this line from the select formula, the report then retrieves the rows containing null rates, but, of course, it no longer excludes the rates I want to exclude.

My question is: How can I retrieve rows with null value rate fields, while still excluding the rows with the values I wish to exclude?

The DB is Sybase 11.

I have set Report Options to Convert Database NULL values to default, but it makes no difference.

Thanks, Cheryl Grothaus