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

Page Header now does not repeat within Export-To-Excel document


For many of our reports were using the Crystal Reports that came with VisualStudio .Net (I think it was version 9). Recently, some of our developers needed to upgrade to Crystal Reports XI release 2. This forced us to install the Crystal 11.5 redistributable on our web servers, so those developers would be able publish their rpt files. However, now we are noticing problems with the export-to-excel feature on some of our old reports. Even though we have not change/touched the reports at all, the export to excel feature is acting differently.

Specifically, these are the things we noticed missing since we installed the XI redistributable on the server...

1. Previously, the export-to-excel would mimic the page breaks we setup in the rpt file. Now it does not. The page breaks seem random.

2. Previously, the head section would repeat within the excel document (that is how we wanted it). Now it does not. The page header only shows up once, but then does not repeat anymore.

Previously, we did not have to set any of the format options in the report, and it worked fine. To try and resolve the problems I have now tried these settings (C#):

ExcelFormatOptions efo = new ExcelFormatOptions();

efo.ExportPageBreaksForEachPage =true;

efo.ExportPageHeadersAndFooters = ExportPageAreaKind.OnEachPage;

Does anyone know how to get my page breaks back?

thanks, --Rick

Edited by: Rick Thiel on Oct 21, 2008 4:59 PM

I am moving this question to the SDK Application Development forum instead.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 31, 2008 at 08:06 PM

    Please post this question in the Business Objects SDK Application Development group...

    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.