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

Search for additional results

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