I've written an executable in VB6 to export a CR 8.5 report to PDF. It works fine on my machine where the VB6 project lies. However, when I try to run the executable on another machine it throws the following error:
-214719854(800473d2): The remaining text does not appear to be part of the formula.
Here is a snippet of the code.
Set crxApp = New CRAXDRT.Application
Set crxReport = crxApp.OpenReport(App.Path & "\" & strReportName)
crxReport.DiscardSavedData
crxReport.Database.Tables(1).SetLogOnInfo "", "", sUser, sPswd
With crxReport.ExportOptions
.DestinationType = crEDTDiskFile
.FormatType = crEFTPortableDocFormat
.DiskFileName = "c:\report.pdf"
End With
crxReport.Export (False)
It appears that the error occurs on the last line. The same error occurs if I set the last line to "true".
Any ideas what's happening?
-214719854(800473d2): The remaining text does not appear to be part of the formula.
Here is a snippet of the code.
Set crxApp = New CRAXDRT.Application
Set crxReport = crxApp.OpenReport(App.Path & "\" & strReportName)
crxReport.DiscardSavedData
crxReport.Database.Tables(1).SetLogOnInfo "", "", sUser, sPswd
With crxReport.ExportOptions
.DestinationType = crEDTDiskFile
.FormatType = crEFTPortableDocFormat
.DiskFileName = "c:\report.pdf"
End With
crxReport.Export (False)
It appears that the error occurs on the last line. The same error occurs if I set the last line to "true".
Any ideas what's happening?