Crystal Report Page Header Not Visible in Export To Excel (Data Only)

Question

I have a report with headers in the page header section, this data is not visible in the "Export to Excel(Data only)" report.

Please let me know what I did that changed this since it used to be visible before the report layout was edited.

Thanks in advance

Solution 1

You can export using the "Export to Excel (Data Only)" option and show page headers in Excel using the default values presented in the export dialog.

It just requires a little trial and error to get working.

Firstly, ensure that your page header text objects exactly match the width of the underlying objects in your detail area.

Make all page header text objects the same height (select all / right click / Size / Same Height).

Align all page header text objects to the top of the page header area. Reduce the height of the page header area so that it almost touches the bottom of the page headers.

Solution 2

1. Open the report in Crystal Reports (XI R2 ~ for me that was)
2. Click on File > Export > Report Export Options...
3. Select the Format option "Micorosoft Excel 97-2000 - Data only (XLS)" and then OK
4. Ensure the option "Custom: Data is exported according to selected options." is selected.
5. If you don't see the available custom options, click on the "Options >>>" button on the right to expand them. At the bottom where all the checkboxes are ensure the option to "Simplify page headers is UNCHECKED!
6. Click OK.
7. Save the report
8. Try rerunning the report to Excel (Data).