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

Symptom

  • 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


Read more...

Environment

  • SAP Crystal Reports 2011 / 2013

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013

Keywords

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 for Me (Login required).

Search for additional results

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