Skip to Content
0
Former Member
Jun 10, 2011 at 05:13 PM

Reports exported to Excel - Formatting issues

98 Views

We have two Business Objects Enterprise servers (boxi r2 and boxi r3.1 sp3) running side by side. We find that reports created using boxi r2 and exported to Excel format look fine. When we run the same report and export to excel using boxi r3.1 sp3, we encounter the following formatting issues:

<ol>

<li>All columns do not fit on pages. The last 2 to 3 columns spill over onto extra pages.</li>

<li>There are some columns where most of the values are blank, but when a row is exported that has a value in that column, all subsequent column positions for that row shift.</li>

<li>All rows do not fit on page. The last two rows flow onto a new page, then there seems to be a page break.</li>

<li>On some reports dates are displayed as ######.</li>

<li>On some reports column headings are not centered.</li>

<li>I would appreciate any input that would help us determine a fix for the formatting issues we are encountering.</li>

</ol>

The report is executed using CrystalDecisions.CrystalReports.Engine.

Here is the code from the application that does the export:

ExportOptions exportOptions = new ExportOptions();

exportOptions.ExportFormatType = ExportFormatType.Excel;

exportOptions.ExportDestinationType = ExportDestinationType.DiskFile;

DiskFileDestinationOptions diskOptions = new DiskFileDestinationOptions();

diskOptions.DiskFileName = filename + ".xls";;

exportOptions.ExportDestinationOptions = diskOptions;

ExcelFormatOptions XLOptions = new ExcelFormatOptions();

XLOptions.ExportPageBreaksForEachPage = true;

XLOptions.ExportPageHeadersAndFooters = ExportPageAreaKind.OnEachPage;

exportOptions.ExportFormatOptions = XLOptions;

rptDoc.Export(exportOptions);

Please note the following details about our environment:

<h5>Report Designers:</h5>CR Designer version: xi Rel 2

<h5>Developer environment</h5>Has the following installed:

- Business Objects Enterprise XI Release 2

- VS .Net 2008

- Crystal reports Basic for Visual Studio 2008

- Crystal Report 2008 Runtime SP3

- Boxi .Net SDK

- SAP BusinessObjects Enterprise XI 3.1 Client Tools sp3

- .Net Version: 2.0

<h5>Crystal Server environment:</h5>Two clustered Business Objects Enterprise servers with the following installed & configured

- Business Objects Enterprise XI Release 2

- Crystal Reports XI Release 2

- SAP BusinessObjects Enterprise XI 3.1 SP3

- .Net Version: 2.0

<h5>Web Servers:</h5>Two load balanced web servers with the following installed and configured

- Business Objects Enterprise XI Release 2

- Crystal Report 2008 Runtime SP3

- Crystal Reports XI Release 2 .Net 2005 Server

- SAP BusinessObjects Enterprise XI 3.1 SP3

- .Net Version: 2.0