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