Crystal Reports Problem
Introduction
We are using Crystal Reports 8.5 to generate reports in our web based application called Portfolio Management System. The front end used in the application is ASP and the database is SQL Server 7.0. The application and the database, both are hosted in the same server. The OS is Win2k with IIS 5 and SP3. We have installed Acrobat Writer 5.0 in the server. Our Application has a functionality of exporting reports to PDF format directly from the front end.
Problem Description
We are able to view reports in our application through the browser using Crystal Reports. Exporting reports to PDF was running perfectly on the live as well as the test server. But now we are getting a run time error while attempting to export crystal report to PDF in the live server only. The same code works fine in the test servers. We tried using the following two methods to export reports to PDF format:
1. When we try to export the report to PDF using the Application front end we get an error page. The error displayed in the error page of the web browser is
“Error Type:
Crystal Reports ActiveX Designer (0x80047784)
Failed to export the report.”
The PDF file was successfully created in the specified directory but the size was
0 kb and there was no data in the file. This means that a PDF file was successfully created but the crystal was unable to export the data to the PDF file.
2. A parameterized report was run using our ASP application and successfully displayed in one of the Crystal web viewers using the ASP Report Server. However, while attempting to manually export the report to PDF, by clicking on the EXPORT button on the toolbar of the web browser, the following error message was displayed:
"CRAXDRT Error occurred on Server -2147190908: Failed to export the report."
We tried to export the report using both the methods mentioned above to RTF and other formats we found that they were working fine and data was exported successfully to the specified file format. Only in PDF we are facing the export problem. We have even tried reinstalling Acrobat Writer 5.0 and Crystal reports software but with no success.
We referred to your Crystal Support site and came across some documentation related to our problem and tried unregistering and registring exportmodeller.dll and crfx_pdf.dll too but with no success.
Please find below a part of the code used in our application for generating and exporting data to PDF format for your reference.
strDiskFileName = strPDFDirectory & familyCode & vntArrreports(intRepCount, 2) & ".pdf"
ExportFileName = strDiskFileName
Path = Request.ServerVariables("PATH_TRANSLATED"
While (Right(Path, 1) <> "\" And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend
ExportDirectory = Path & "pdf\" & cstr(session("user_cd") & "\"
ExportType = "31"
CrystalExportOptions.DiskFileName = ExportDirectory & ExportFileName
CrystalExportOptions.FormatType = CInt(ExportType)
CrystalExportOptions.DestinationType = CInt(1)
Session("oRpt".Export False
We urgently need your assistance in solving this problem. Kindly provide us with a suitable solution to solve this problem as soon as possible as this problem is severely affecting the working of our application.
Introduction
We are using Crystal Reports 8.5 to generate reports in our web based application called Portfolio Management System. The front end used in the application is ASP and the database is SQL Server 7.0. The application and the database, both are hosted in the same server. The OS is Win2k with IIS 5 and SP3. We have installed Acrobat Writer 5.0 in the server. Our Application has a functionality of exporting reports to PDF format directly from the front end.
Problem Description
We are able to view reports in our application through the browser using Crystal Reports. Exporting reports to PDF was running perfectly on the live as well as the test server. But now we are getting a run time error while attempting to export crystal report to PDF in the live server only. The same code works fine in the test servers. We tried using the following two methods to export reports to PDF format:
1. When we try to export the report to PDF using the Application front end we get an error page. The error displayed in the error page of the web browser is
“Error Type:
Crystal Reports ActiveX Designer (0x80047784)
Failed to export the report.”
The PDF file was successfully created in the specified directory but the size was
0 kb and there was no data in the file. This means that a PDF file was successfully created but the crystal was unable to export the data to the PDF file.
2. A parameterized report was run using our ASP application and successfully displayed in one of the Crystal web viewers using the ASP Report Server. However, while attempting to manually export the report to PDF, by clicking on the EXPORT button on the toolbar of the web browser, the following error message was displayed:
"CRAXDRT Error occurred on Server -2147190908: Failed to export the report."
We tried to export the report using both the methods mentioned above to RTF and other formats we found that they were working fine and data was exported successfully to the specified file format. Only in PDF we are facing the export problem. We have even tried reinstalling Acrobat Writer 5.0 and Crystal reports software but with no success.
We referred to your Crystal Support site and came across some documentation related to our problem and tried unregistering and registring exportmodeller.dll and crfx_pdf.dll too but with no success.
Please find below a part of the code used in our application for generating and exporting data to PDF format for your reference.
strDiskFileName = strPDFDirectory & familyCode & vntArrreports(intRepCount, 2) & ".pdf"
ExportFileName = strDiskFileName
Path = Request.ServerVariables("PATH_TRANSLATED"
While (Right(Path, 1) <> "\" And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend
ExportDirectory = Path & "pdf\" & cstr(session("user_cd"
) & "\"ExportType = "31"
CrystalExportOptions.DiskFileName = ExportDirectory & ExportFileName
CrystalExportOptions.FormatType = CInt(ExportType)
CrystalExportOptions.DestinationType = CInt(1)
Session("oRpt"
.Export FalseWe urgently need your assistance in solving this problem. Kindly provide us with a suitable solution to solve this problem as soon as possible as this problem is severely affecting the working of our application.