SAP Knowledge Base Article - Public

1283120 - Gridlines missing in MS-Excel, when exporting a report with a cross-tab to MS Excel from Crystal Reports

Symptom

  • Missing lines.
  • No Gridelines.
  • Cross-tab outline missing in Excel.
  • Cross-tab borders not visible in MS Excel.
  • Cross-tab lines disappears after exporting a report from Crystal Reports to MS Excel Data-Only format.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
           
  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Add a cross-tab to the report.
  3. Export the report to MS-Excel (Data-Only)
  4. In MS Excel, open the exported document, and notice the Gridlines of the rows and columns of the cross-tab, are not visible.
      
    Cross-tab Gridlines.png

Cause

  • When exporting to MS Excel or MS Excel Data-Only, it exports the cross-tab data to rows and columns, and the cross-tab gruidlines are the actual MS Excel rows and columns. 
      
  • Note: It is possible to export some limitted formatting to MS Excel Data-Only, like font size and colors, by selecting the exporting option "Export Object Formatting", but it does not includes lines, therefore the outcome will be the same, and this is normall behavior.

Resolution

  • Unfortunately, it is not possible to export the cross-tab gruidlines to MS Excel, and this is why there is no lines in the MS Excel spreadsheet generated.
        
  • For the list of Crystal Reports features supported by exporting format, see the SAP Knowledge Base Article:
      
     1946358 - Crystal Reports features supported by exporting format

Keywords

Lines,MS Excel. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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