Dealing with Nulls

I have the following formula in my crystal report done in .net:


(If {?Electric Rate} = 'All' then {MyTable.RateCode}={MyTable.RateCode}
else UpperCase({?Electric Rate}) = UpperCase({MyTable.RateCode}))


When I run this report choosing 'All' it won't pull in records where MyTable.Ratecode is null. How can I alter this formula to bring in records where MyTable.RateCode is null. Thanks in advance.

Open your report in Crystal, select File|Report Options. There is a checkbox labelled Convert Null Field Value to Default. If you check this box, it should handle Null fields properly.

Hope that helps.

Your suggestion solved my problem. Thanks.