1831798 - Incorrect Group Outlines when exporting from Crystal Reports to MS Excel Data-only format

SAP Knowledge Base Article - Public

1831798 - Incorrect Group Outlines when exporting from Crystal Reports to MS Excel Data-only format

Symptom

  • Incorrect Group Outlines when exporting from Crystal Reports to MS Excel Data-only format.

1831798_3.jpg

Environment

  • Crystal Reports 2008 SP5
  • Crystal Reports 2011
  • Crystal Reports 2013
  • Microsoft Excel 

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Insert a couple of database fields in the details section of the report.
  3. Insert at least one group on the report.
  4. Under the menu “Insert”, select “Group”
  5. In the “Insert Group” window, select a database fields to group by and click “OK”
  6. Export the report to MS Excel Data-Only format, and check the option “Show group outlines”
  7. Under the menu “File”, select “Export – Export Report”
  8. In the “Export” window, select the exporting format: “Microsoft Excel (97-2003) Data-only”, and click "OK" 
     
    1831798_1.jpg
         
  9. In the “Excel Format Options” window, check the option “Show group outlines”, and click “OK”
       
    1831798_2.jpg
      
  10. Open the report in MS Excel, and notice the outline is incorrect.

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01686034

Resolution

  • The issue is resolved in the following product updates:
      
    • Crystal Reports 2008:
      • Fix Pack 6.2
           
  • The issue is planned to be resolved in the following future product updates:
      
    • Crystal Reports 2008:
      • Service Pack 7
         
    • Crystal Reports 2013
      • Support Pack 2
           
    • SAP Crystal Reports, developer version for Microsoft Visual Studio
      • Service Pack 7

 

Keywords

CR, Group outline, xls , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

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

Attachments

1831798_1.jpg