SAP Knowledge Base Article - Preview

1930599 - How to change Database Null from 0 to empty value in Crystal Report 2011 and Crystal Report 2013 when use the BW BEx Query as data source


  • The Crystal Report was developed by using BW BEx Query as the data source
  • After refreshed the report, some values for the Key Figures will display as number 0 or 0.00
  • If we run the query with RSRT transaction from BW, such values will display as empty since these are NULL value in BW



  • SAP Crystal Reports 2011 / 2013


SAP Crystal Reports 2011 ; SAP Crystal Reports 2013


crystal report, cr, 2011, 2013, cr 2011, cr 2013, null, database null, mdx, bw mdx, bex query, empty value, TreatSAPNULLAsDatabaseNULL, Convert Database Null Values t Default, Convert Other Null Values to Default, BI 4.0, BI 4.1, 4.0, 4.1, rsrt , 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 ONE Support launchpad (Login required).

Search for additional results

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