crystal reports export to excel data only missing page header names

Posted on 2009-04-29
Last Modified: 2012-05-06
when I export the crystal report to excel for data only and found out page header names are missing when I open the excel file.  While the column names are exported without problem. Is there any way we can use to export page header also?

Thank you !
Question by:FinghtingMiao
    LVL 7

    Expert Comment

    Select File>Export>Report Export Options

    Select the Excel option from the drop down list and hit OK
    In the dialog box, Select the appropriate option from the 'export page headers and page footers' drop down. It's probably currently set to 'none'
    LVL 18

    Expert Comment

    Do you have "Export page header and page footer" checked in the export options?  When you say column names are exported without a problem, which section do those column names come from?

    Author Comment

    I do have "Export page header and page footer" checked in the export options.
    My column name are placeed at page header #2, while report title placed at page header #1 which is not exported .

    LVL 7

    Accepted Solution

    In the same maintenance screen, try selecting 'excel - data only', hit options and ensure that simplify headers is un-checked
    LVL 100

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now