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

[Former Member]

Set the formula editor to your suggestion and I am still losing records,  could the problem come from the way I have the tables linked in the Database Expert?

[abhilash_kumar]

Could you post the record selection formula here?

Go to Report > Selection formulas > Record

-Abhilash

[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