Crytal报告未在Visual Studio 2003中打开 [英] Crytal Report is not Opening in Visual Studio 2003

问题描述

我有一台Vitual PC（Microsoft Windows Server 2003 R2，Service Pack 2），其中Visual Studio 2005 Professional Edition和Visual Studio 2003安装在我的 机器。

我们有一个用VB.NET 2003编写的应用程序，它内置了Crystal报告。

问题是，在尝试将报表导出到Excel时，水晶报表未打开，抛出异常。我在Visual Studio 2003中运行它。

代码snipet是：

私人 Sub ExportPDF（ ByVal reportTemplate As String ， ByVal reportDataSet As DataSet， ByVal reportName As String ， ByVal outputType As String ）

Dim ExportPath 如 String

Dim crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument

ExportPath = Server.MapPath（ String .Format（" {0} / Reports / PassengerRevenue /"，rootFolder））

Dim fileExtension As 字符串 = 字符串 .Empty

Dim exportFormat As CrystalDecisions.Shared.ExportFormatType

Dim contentType As 字符串 = 字符串 .Empty

选择 Case outputType.ToUpper（）

Case " EXCEL" '导出为Microsoft Excel格式

fileExtension =" .xls"

exportFormat = ExportFormatType.Excel

contentType =" application / vnd.ms-excel"

案例 Else '默认为PDF格式

fileExtension =" .pdf"

exportFormat = ExportFormatType.PortableDocFormat

contentType =" application / pdf"

结束 选择

crReportDocument = 新 CrystalDecisions.CrystalReports.Engine.ReportDocument

crReportDoc ument.Load（ExportPath& reportTemplate）

如果 不 reportDataSet < font color ="＃0000ff"size = 2> Nothing 然后

crReportDocument.SetDataSource（reportDataSet）

End 如果

'为报告设置导出选项后，即可导出报告。

尝试

'将报告导出为直接流

Dim oStream As 新 MemoryStream

'crReportDocument.Export（）

Response.Clear（）

oStream = CType < font color ="＃000000">（crReportDocument.ExportToStream（exportFormat），MemoryStream）' ------------------ ------>在此行抛出异常

Response.ContentType = contentType

Response.AddHeader（" Content-Disposition"，" attachment） ; filename ="& reportName& fileExtension）

Response.BinaryWrite（oStream.ToArray（））

Response.End（）

Catch err As Exception

Response.Write（err.ToString）

Response.End（ ）

结束 尝试

结束 Sub

" oStream = CType （crReportDocument.ExportToStream（exportFormat），MemoryStream）" 正如代码中提到的那行抛出异常：

CrystalDecisions.CrystalReports.Engine.ExportException：文件C中的错误：\ cc_view \ aroy_view \ entity \ Domains \ HumanContactSupport\Contact Applications \ BusinessApplications \Web\Reports\PassengerRevenue\PR_Inventory.rpt：导出DLL检测到错误：at。我（String，EngineExceptionErrorID）at。 D（Int16，Int32）at。 C（Int16）位于CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream（ExportRequestContext reqContext）的CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream（ExportFormatType formatType），位于TransiT.HumanContactSupport.BusinessApplications.UIViews.CreateReportCriteria.ExportPDF（String reportTemplate，DataSet reportDataSet） ，字符串reportName，String outputType）在C：\ cc_view \aroy_view \\\实现\ Domains \HumanContactSupport \Contact Applications \ BusinessApplications \ UIViews \RevenueReporting\CreateReportCriteria.ascx.vb：第476行

请回复解决这个问题。这是非常紧急的问题。我无法解决。

解决方案

阅读其他论坛 http://forums.msdn.microsoft.com/en-US/vscrystalreports/thread/c11d5168-8ee1-49b1-aa45-800c09e46b71

 

I have a Vitual PC(Microsoft Windows Server 2003 R2,Service Pack 2)in which Visual Studio 2005 Professional Edition and Visual Studio 2003 installed in my machine.

 

 We have an application written in VB.NET 2003 which has built in Crystal reports.

The problem is that ,crystal report is not opening, throwing exceptions when  try to export a report to Excel. i am running it in Visual Studio 2003 .

 

The code snipet is :

 

 

 

Private Sub ExportPDF(ByVal reportTemplate As String, ByVal reportDataSet As DataSet, ByVal reportName As String, ByVal outputType As String)

Dim ExportPath As String

 

Dim crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument

ExportPath = Server.MapPath(String.Format("{0}/Reports/PassengerRevenue/", rootFolder))

Dim fileExtension As String = String.Empty

Dim exportFormat As CrystalDecisions.Shared.ExportFormatType

Dim contentType As String = String.Empty

Select Case outputType.ToUpper()

Case "EXCEL" 'Export to Microsoft Excel format

fileExtension = ".xls"

exportFormat = ExportFormatType.Excel

contentType = "application/vnd.ms-excel"

Case Else 'By default PDF format

fileExtension = ".pdf"

exportFormat = ExportFormatType.PortableDocFormat

contentType = "application/pdf"

End Select

 

crReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument

crReportDocument.Load(ExportPath & reportTemplate)

If Not reportDataSet Is Nothing Then

crReportDocument.SetDataSource(reportDataSet)

End If

'Once the export options have been set for the report, the report can be exported.

Try

'Export the report as a direct stream

Dim oStream As New MemoryStream

'crReportDocument.Export()

Response.Clear()

oStream = CType(crReportDocument.ExportToStream(exportFormat), MemoryStream) '------------------------> In this line throwing exception

Response.ContentType = contentType

Response.AddHeader("Content-Disposition", "attachment; filename=" & reportName & fileExtension)

Response.BinaryWrite(oStream.ToArray())

Response.End()

Catch err As Exception

Response.Write(err.ToString)

Response.End()

End Try

End Sub

 

"oStream = CType(crReportDocument.ExportToStream(exportFormat), MemoryStream)" As mentioned in the code that line is throwing exception :

 

CrystalDecisions.CrystalReports.Engine.ExportException: Error in File C:\cc_view\aroy_view\implementation\Domains\HumanContactSupport\Contact Applications\BusinessApplications\Web\Reports\PassengerRevenue\PR_Inventory.rpt: Error detected by export DLL: at .I(String , EngineExceptionErrorID ) at .D(Int16 , Int32 ) at .C(Int16 ) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at TransiT.HumanContactSupport.BusinessApplications.UIViews.CreateReportCriteria.ExportPDF(String reportTemplate, DataSet reportDataSet, String reportName, String outputType) in C:\cc_view\aroy_view\implementation\Domains\HumanContactSupport\Contact Applications\BusinessApplications\UIViews\RevenueReporting\CreateReportCriteria.ascx.vb:line 476

 

 

Please reply  to solve this problem.This is very urgent issue.I am not able to solve.

 

解决方案

read this other forum http://forums.msdn.microsoft.com/en-US/vscrystalreports/thread/c11d5168-8ee1-49b1-aa45-800c09e46b71

这篇关于Crytal报告未在Visual Studio 2003中打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！