导出水晶报表时无法打开连接
我正尝试将我的水晶报表导出为pdf,但仍然收到“无法打开连接”错误。这似乎是在CR.Export行发生错误。我尝试了一切,但不知道如何解决它。仅供参考,它在我的开发服务器上工作,但是当我将它复制到生产服务器时,出现错误。所以很难确定它发生的位置。导出水晶报表时无法打开连接
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
Try
InitializeComponent()
strPermitNo = Session("RecordID")
SpWithViewer(strPermitNo)
CrystalReportViewer2.DataBind()
Catch er As Exception
LogError(er.ToString, "PageInit-PrintPermit1.aspx")
Exit Try
Finally
End Try
End Sub
` 保护小组btnExport_Click(发送者为对象,例如作为EventArgs的)把手btnExport.Click
strPermitNo = Session("RecordID")
Try
Dim CrExportOptions As ExportOptions
Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions()
Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions()
CrDiskFileDestinationOptions.DiskFileName = "\\idsfmsrvr\wwwroot\FWPDFs\" & strPermitNo & ".pdf"
strAttachment = "\\idsfmsrvr\wwwroot\FWPDFs\" & strPermitNo & ".pdf"
Session("Attachment") = strAttachment
CrExportOptions = CR.ExportOptions
If True Then
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions
CrExportOptions.FormatOptions = CrFormatTypeOptions
End If
CR.Export()
EmailPermitToApplicant()
File.Delete(strAttachment)
lblMsg.Text = "Permit has been emailed to applicant."
lblMsg.Visible = True
Catch er As Exception
LogError(er.ToString, "btnExport()-PrintPermit1.aspx")
Exit Try
Finally
connFTS.Close()
End Try`
CrystalDecisions.CrystalReports.Engine.InternalException:无法打开连接。详细信息:[数据库供应商代码:4060]无法打开连接。 FWPermit_5 {E97E0F6A-7F39-43A3-A1B6-3225E4F78289} .rpt详细信息:[数据库供应商代码:4060] ---> –
就像我之前提到的,出口在开发中工作,但不在生产中。 –
检查您的网络,连接字符串..有时水晶报表需要在显示并运行之前登录到您的工作数据库中。 –
你能在这里显示确切的错误吗? –