SAP Knowledge Base Article - Public

2944088 - Cross-Tab row value blank, when exporting a report to MS Excel - Data Only, from Crystal Reports

Symptom

  • Cross-Tab Row Name missing.
  • Cross-Tab headers for rows are blank when exported to MS Excel - Data Only.
  • In Crystal Reports, when exporting a report to MS Excel - Data Only, or MS Excel Workbook, it does not export the cross-tab row name. 
      
    Example: The first cross-tab column based on country, is missing in excel. 

    Cross-Tab-Excel - 02.png
     
          
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a report based on any data source.
  2. Insert a cross-tab with multiple rows.
  3. Format the cross-tab to display the column Totals at the bottom.
  4. Export the report to MS Excel - Data Only.
  5. When opening the exported report in MS Excel, notice the first row headers are not displayed. It is blank.

Cause

  • Cross-tab rows headers are exported to MS Excel - Data Only, but by design, it exports on the same row as the row Total.
         
  • In other words, the header for the first cross-tab row value will not appear at the top, like it does in Crystal Reports, but will appear at the bttom, on the same row as the Total. 

    Cross-Tab-Excel - 01.png
      

Resolution

  • To export the cross-tab row value at the top:
    • Export the report to MS Excel ( 97-2003) as this format retain as much formatting as possible; or
    • Export the rpeort to MS Excel - Data Only, but format the cross-tab to display the Totals on Top.
         
         
  • To format a cross-tab in Crystal Reports to display the Totals on Top:
    1. Right click on the cross-tab, and select "Cross-Tab Expert..."
        
    2. In "Cross-Tab Expert", select the tab "Customize Style"
        
    3. Check the option "Column Totals on Top"
        
       Cross-Tab-Excel - 03.png 
         

    4. Click "OK" to accept the change.

See Also

[Enter your See Also here...]

Keywords

CR, xport, xls, xlsx , 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