Column headings are misplaced in MS Excel(Data Only) format

From DocWiki

Column headings are misplaced in MS Excel(Data Only) format

Problem Summary

Column headings are misplaced in MS Excel(Data Only) format

Error Message

NA

Possible Cause

Limitation of Crystal Reports which is a third party application.

Recommended Action

If you try to export from 'Crystal reports Viewer' of HRC, then you will get 'Excel Format options' window during export operation to set the format of the excel. You may remove the headers of the report by removing the check mark of the option 'Export Page Header and page Footer'. This will remove the headers and give a better look for the report.

If you try to schdule the report, please aware about this limitation.Alternatively, you can schedule the reports with the format 'Microsft Excel 97-2000(XLS)'