SAP Knowledge Base Article - Preview

1216567 - How to export a report to multiple Excel worksheets in Crystal Reports?

Symptom

  • Exporting to multiple Excel worksheets.
  • How to export data to different tabs in MS Excel?
  • How to export the groups of a report to separate Excel worksheets, when exporting a report to MS Excel from Crystal Reports?
      
    For example:
      
    If you have a report grouped by Country, and want to export the group displaying USA to one worksheet,  the group for France to another worksheet, etc... within the same Excel workbook.


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

EXCEL EXPORT WORKSHEET WORKBOOK MULTIPLE SPECIFY MS GROUPS GROUPING GROUP Crystal Reports for Visual Studio Export to Excel Multiple worksheets , c2014059 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.