SAP Knowledge Base Article - Preview

1199467 - When there is null data, formula returns different results than expected in Crystal Reports

Symptom

  • Formula not displaying the expected result.
  • Formula output is blank, when expecting a specific value, or formatting, when the data set contains null values.
  • When refreshing a report in Crystal Reports that contains null data, the result of the Formula, or Record Selection Formula, or Conditional Object Formatting is incorrect, even when using the function isNull in the formula.


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020     

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

IsNull, NULL values, formula, selection formula, different results , 4647423, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.