SAP Knowledge Base Article - Preview

2939999 - Summaries are not exported to Excel summary function, when exporting a report to MS Excel - Data Only, from Crystal Reports

Symptom

  • Total show as a value in excel.
  • Total not exported to MS Excel formula function.
  • Report with few values exports the summary to MS Excel as Excel function, like: SUM(A1;A4;A7,... )
  • When exporting a report to MS Excel - Data Only (.xls) with a larger data set, and selecting the option "Use worksheet functions for summaries", the summary shows the values, instead of the expected Excel function, like: SUM(A1;A4;A7,... )


Read more...

Environment

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

Product

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

Keywords

CR,xls , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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.