SAP Knowledge Base Article - Public

1301817 - Crystal Report when exported to MS-Excel(Data Only) the column spread into multiple columns

Symptom

Crystal Report when exported to MS-Excel(Data Only) the columns of the Excel file spread to multiple columns.

Environment

  • Crystal Reports 2008
  • MicroSoft Excel 2003 SP2
  • MicroSoft Excel 2007

Reproducing the Issue

  1. Open the Crystal Report in CR Designer.
  2. Click on File -> Export -> Export report.
  3. Select Microsoft Excel –Data Only(XLS)
  4. Click on Ok
  5. Click on Options
  6. Select “Details” in the Drop Down box
  7. Check the options Maintain relative object position and Maintain column alignment
  8. Click on OK
  9. Save the excel file on the machine(Disk)  
  10. View the Excel file.
  11. The exported file shows that the second column from left Matt Cont is not spread over to the adjoining columns.

Resolution

  1. Click on the Export button.
  2. Select Excel data Only format from the drop down.
  3. In the Excel Format options, uncheck "Simplify page headers".
  4. Select other options as necessary.
  5. Once this is done, check the exported excel file. Now there must be no missing header columns.
  6. If "Simplify page headers" is checked, the page header is being read only once and does not show the values on the second line causing the issue to appear.

Keywords

formatting lost,crystal report export, excel data only,multiple columns , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0