Missing Data

[Former Member]

Crystal Reports 13:  When I add a formula field to my report,  Crystal drops records that seem to have a null date or the default of 12/30/1899.  I have found a discussion about the missing data on the SAP Community where they use Joins or Unions to solve the problem.  Having trouble understanding if this is what I need to be using since it is referring to joining tables not strings.  Any help would be greatly appreciated.  My formula is below:

Formula.txt.zip

[abhilash_kumar]

Hi Robbie,

CR stops executing the formula when it encounters a NULL value, unless you explicitly handle NULL values using the IsNull function or by setting the formula editor to use 'Default Values for NULLS'

Open the Formula Editor and you should see a drop-down on the top that reads 'Exceptions for Nulls'; set that to 'Default Values for Nulls'.

-Abhilash