Excel Export Fails in Windows 2003 Server

[Former Member]

In my development environment, I am deploying an classic ASP web site on a Windows 2003 server (sp2).

It is exporting the crystal reports to excel.

In my UAT environment, I am deploying the same ASP web site on a windows 2003 server (sp2) R2. (Release 2).

However, it is failing while exporting the crystal reports to excel.

Both development and UAT Site is using Crystal reports XI.

The other difference between development and UAT environment is ,

Development environment is installed with MsOffice 2000 whereas NO MsOffice is installed in UAT Enviornment.

CODE: (Failing at the last line Session("oRpt").Export false )

Set crystalExportOptions = Session("oRpt").ExportOptions

crystalExportOptions.DiskFileName = application("RptEmailPath") & FileName

crystalExportOptions.DiskFileName = crystalExportOptions.DiskFileName & ".xls"

crystalExportOptions.FormatType = 21

crystalExportOptions.DestinationType = cint(1)

Session("oRpt").Export false

Please help me to sort out the issue.

[Former Member]

Crystal Report service pack II is required to work excel export option.

[Former Member]

Hi,

This is issue was getting resolved after installing Crystal Report Service Pack II.

Go to

Start --> Programs -> Business Objects --> Crystal Reports Server --> Central Configuration Manager

The version number in this window clearly shows which version of the service pack has been installed in a system.

If it is 11.5.8.826 means system is installed with Crystal Report Service pack II.

Thanks,

Muthu T.

[former_member11696]

Please re-post if this is still an issue to the Legacy Application Development SDKs Forum or purchase a case and have a dedicated support engineer work with you directly