SAP Knowledge Base Article - Public

1831798 - Incorrect Group Outlines when exporting a report with groups, to MS Excel Data-only format, from Crystal Reports

Symptom

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

1831798_3.jpg

Environment

  • SAP Crystal Reports 2008 
  • SAP Crystal Reports 2011
  • SAP 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   
      • 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 Business View Manager , Bug Filed

Product

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

Attachments

1831798_1.jpg