Excel Export Fails in Windows 2003 Server

18 Views

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.