SAP Knowledge Base Article - Public

3766148 - IsNull() function displaying blank for no data instead of a specific value after Crystal Reports 2025 update

Symptom

  • IsNull() function displaying blank for no data instead of a specific value in Crystal Reports designer.
  • Issue started from SAP Crystal Reports 2025 Patch 10.
  • It is working as expected in Patch 9. 

Environment

  • SAP Crystal Reports 2025 Patch 11
  • SAP Crystal Reports 2025 Patch 10

Reproducing the Issue

  1. Create a new crystal report based on any data source.
  2. Create a formula that will verify if a database field is null or not:

    If IsNull({Database.Field}) Then
    "No Data"
    Else
    "Data"

  3. Insert the formula on the report.
  4. Observe when there is no data it shows blank instead of displaying 'No Data'.

Cause

  • It is a regression from SAP Crystal Reports 2025 Patch 10.

Resolution

  • The issue is currently under investigation by Development.

Keywords

IsNull() function formula no data CR Crystal Reports 2025 Patch 10 Patch 11 empty isnull blank , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2025