Skip to Content
author's profile photo Former Member
Former Member

Microsoft Excel Workbook data-only, export missing Page Headers

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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 22, 2014 at 01:09 AM

    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


    Untitled.jpg (63.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2014 at 03:37 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.