SAP Knowledge Base Article - Public

1260151 - CR XI R2 Export to multiple Excel worksheets


Can Crystal Reports export to multiple Excel worksheets?

Reproducing the Issue

User wants to export groups of data to seperate Excel sheets.


User wants to see grouped data on it's own sheet


Crystal Reports is not designed for this

It exports the data to excel on one sheet. It will not move to a second sheet until 64k of data has been written to the 1st sheet.


64000, export, excel, worksheet, separate, groups , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


SAP Crystal Reports XI