SAP Knowledge Base Article - Public

1260151 - CR XI R2 Export to multiple Excel worksheets

Symptom

Can Crystal Reports export to multiple Excel worksheets?

Reproducing the Issue

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

Cause

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

Resolution

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.

Keywords

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

Product

SAP Crystal Reports XI