SAP Knowledge Base Article - Public

2937950 - Large report Export to Excel (Data only) takes longer than expected in Crystal Reports 2016

Symptom

  •  Export to Excel Workbook Dta Only takes 6 times longer on a Cloud environment
  • Same report on premise machine takes less than 5 minutes

Environment

  • SAP Crystal Reports 2016
  • Report with over 300 000 records
  • Cloud Platform with Windows OS

Reproducing the Issue

  1. Open large report in Crystal Reports 2016
  2. Export the report to Excel Data Only 

Cause

Resolution

  • Disable Fair Share technology to manage resources

Keywords

performance, Excel worksheet , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2016