SAP Knowledge Base Article - Preview

1972949 - Formatting for object that returns a NULL value display in MS Excel, when exporting a report to MS Excel Data-Only from Crystal Reports

Symptom

  • Excel spreadsheet displays objects that are not on the report.
  • When exporting a report to MS Excel Data-Only, and selecting the option to export object formatting, the objects formatting that returns a NULL value will be part of the output in the MS Excel spreadsheet, where in previous version of Crystal Reports, it was not.
      
            
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013

Keywords

CR, XL, NULL, Empty value , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

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.