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
- Open large report in Crystal Reports 2016
- Export the report to Excel Data Only
Cause
- Fair Share technology to manage resources activate by default on Windows OS
- The problem documented in: https://support.microsoft.com/en-us/help/4494631/fair-share-technologies-enabled-by-default-in-remote-desktop-services#:~:text=Remote%20Desktop%20Services%20(RDS)%20in,network%20bandwidth%20and%20disk%20resources.
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