Skip to Content
0
Former Member
Apr 19, 2009 at 11:38 PM

Crystal Report 2008 doesn't set page size when export to excel file

62 Views

Hi,

I am using Crystal Report 2008 Developer edition.

At Crystal report design time setting the below page setup:

Page Options -


to A3(297X420 mm)

Orientation --- Landscape

and using the following code in .net (c#)

I am using below format options to export in excel in .net 2005

ReportDocument oReport = new ReportDocument();

oReport.FormatEngine.PrintOptions.PaperOrientation = PaperOrientation.Landscape;

oReport.FormatEngine.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA3;

if (aParamlist.ReportFormat == ReportFormatEnum.MicrosoftExcel)

{

ExcelFormatOptions excel = new ExcelFormatOptions();

excel.ExcelUseConstantColumnWidth = false;

// Use detail section one as a guideline to determine column width

excel.ExcelAreaGroupNumber = 1;

//excel.ExcelAreaType = AreaSectionKind.Detail;

excel.ExcelAreaType = AreaSectionKind.Detail;

// Prepare exporting options

ExportOptions export = oReport.ExportOptions;

export.FormatOptions = excel;

export.ExportFormatType = ExportFormatType.Excel;

}

oReport.Export();

when export to excel it doesn't set the Paper Size to A3(297X420 mm).

Is there any way to set the paper size while export to excel or in other formats also????

Thanks & Regds,