Crystal Reports slow export to Excel - (More Records)

[former_member1349076]

Hi Team,

We are noticing an issue while exporting to Excel from Crystal. Same issue in both Crystal 2011 and 2020.

This was not the case when users were in Windows 7 and exporting to xlsx from Crystal. We strated noticing the slowness after moving to Windows 10.

The number of columns and data are huge.

Thanks,

Usha

[lenastodal]

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html
By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html

[former_member11696]

Just a reminder that Crystal Reports is a Database Reporting tool and not a Database Archiving tool. Your DB is much more efficient at archiving data.

Windows OS's manage resources differently from version to version.

CR is hardware and software reliant, one of the biggest issue with large amount of data is the memory handler Windows Uses. CR requires contiguous blocks of memory, meaning in defragmented blocks of memory. Windows is not capable of defragging memory, closing and rebooting is the only way.

I believe Windows 10 has a 8 gig minimum memory size, you could try adding more.

Excel can use a huge amount of memory also.

I can only suggest you find out where that limit is and don't go above it, export your data into smaller file sizes.