Question Re: Missing Data in Technology Q&A

Missing Data

Former Member — Wed, 16 Mar 2016 18:17:47 GMT

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:

Re: Missing Data

abhilash_kumar — Wed, 16 Mar 2016 18:28:00 GMT

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

Re: Missing Data

Former Member — Thu, 17 Mar 2016 13:36:41 GMT

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?

Re: Missing Data

abhilash_kumar — Thu, 17 Mar 2016 13:45:00 GMT

Could you post the record selection formula here?

Go to Report > Selection formulas > Record

-Abhilash