1492677 - Is it possible to export groups or subreports to separate tabs, when exporting a report to MS Excel form Crystal Reports?

SAP Knowledge Base Article - Public

1492677 - Is it possible to export groups or subreports to separate tabs, when exporting a report to MS Excel form Crystal Reports?

Symptom

  • Can we export the subreport to separate tabs?
  • Can we export groups to different tabs in Excel?
  • Is it possible to export subreports or groups to seperate tabs in MS Excel, when exporting a report to MS Excel format from Crystal Reports?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
                  
  • SAP Crystal Reports for Enteprise 4.0
  • SAP Crystal Reports for Enteprise 4.1
  • SAP Crystal Reports for Enteprise 4.2

Reproducing the Issue

  1. In Crystal Reports create a report off any data source.
  2. Insert one or more subreports to the report, or insert one group.
  3. Export the report to MS Excel format.
     
    Notice that all the data is exported in one spreadsheet in MS Excel. How to export the subreports data or groups to different tab of the speadsheet in MS Excel?

Cause

  • There is no option in Crystal Reports or Crystal Reports for Enterprise to export subreports or groups to different tabs of a spreadsheet when exporting a report to MS Excel format.

Keywords

multiple tabs , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016