Microsoft Excel Workbook data-only, export missing Page Headers

[Former Member]

We are currently utilizing 'Page Headers' rather than 'Report Headers' as a means to add header information to each page of the report.  We recently upgraded to BI 4.1 sp2 with Crystal Reports 2013.  All the export options for 'Microsoft Excel (97-2003)****' function such that when exported, the 'Page Header' we have on  Page 1 is re-created at the top of the extract.  Subsequent page headers are not created in the 'xls' version.

When we attempt to export the same report using the 'Microsoft Excel Workbook data-only' it does not contain the 'Page Headers'. 

For Example:

Microsoft Excel (97-2003) data-only output:

Report Header 1

Page Header 1

Column 1, Column 2

data, data

data, data

Microsoft Excel (97-2003) data-only output:

Report Header 1

Column 1, Column 2

data, data

data, data

We are utilizing the Crystal Reports Java SDK to generate these extracts, and were curious if there is a programmatic way around this issue, or a way to place the 'Page Header' back in on export.  A setting in Crystal, an API call, other?

Thanks!

[JWiseman · Accepted solution]

hi Nick,

when you choose the excel data only option, check on Custom for the Excel Format, press the Options button, and there is an option to show Page Headers and Footers.

-jamie

[Former Member]

Yes we had to check this setting for each report and it was successfully exported.  Thank you!