Crystal deals with Nulls in a slightly different way than you might expect. If you do not tell each formula what to do with Nulls or to 'use default values for Nulls' and it hits a Null on your row it will not evaluate the formula for that row and returns nothing.
You can write the formula to explicitly handle nulls as Keikoku has given you or you can set the formula to use 'default values for Nulls'.
This option should be in a drop down list in the formula workshop in the expression editor.
Also note, when dealing with Nulls in the written formula you have to write the Null portion as the first part of the statement.
This works to insert the word NULL for null values...
if isnull(field1) then 'This is NULL' else
if field1='A' then 'This is A' else
if field1<>'A' then 'This is not A'
This does not work to insert the word NULL for null values...
if field1='A' then 'This is A' else
if field1<>'A' then 'This is not A' else
if isnull(field1) then 'This is NULL'
IP Logged
