首页 文章

Crystal Reports - objRpt.SetDataSource()

提问于
浏览
1

我在我的表单上创建了一个名为Inv1和CrystalReportViewer1对象的新Crystal报表,它使用一个强定义的数据集来显示表中完美运行的所有记录 . 但是我现在正试图将我的结果限制为仅根据下面的SQL SELECT语句显示1条记录 . 但我在Crystal Reports下面收到运行时错误 .

错误收到......


System.IO.FileNotFoundException未处理HResult = -2147024894消息=无法加载文件或程序集'file:/// C:\ Program Files(x86)\ SAP BusinessObjects \ Crystal Reports for .NET Framework 4.0 \ Common \ SAP BusinessObjects Enterprise XI 4.0 \ win32_x86 \ dotnet1 \ crdb_adoplus.dll'或其依赖项之一 . 该系统找不到指定的文件 . Source = mscorlib FileName = file:/// C:\ Program Files(x86)\ SAP BusinessObjects \ Crystal Reports for .NET Framework 4.0 \ Common \ SAP BusinessObjects Enterprise XI 4.0 \ win32_x86 \ dotnet1 \ crdb_adoplus.dll FusionLog ====预绑定状态信息===日志:Where-ref绑定 . 位置= C:\ Program Files(x86)\ SAP BusinessObjects \ Crystal Reports for .NET Framework 4.0 \ Common \ SAP BusinessObjects Enterprise XI 4.0 \ win32_x86 \ dotnet1 \ crdb_adoplus.dll日志:Appbase = file:/// C:/ Users / rob / Documents / DEVELOPMENT / PMSLinx / PMSLinx / bin / Debug / LOG:Initial PrivatePath = NULL

调用程序集:(未知) .

日志:此绑定在LoadFrom加载上下文中开始 . 警告:不会在LoadFrom上下文中探测本机映像 . 原生图像只能在默认加载上下文中进行探测,就像使用Assembly.Load()一样 . 日志:使用应用程序配置文件:C:\ Users \ rob \ Documents \ DEVELOPMENT \ PMSLinx \ PMSLinx \ bin \ Debug \ PMSLinx.vshost.exe.config日志:使用主机配置文件:日志:使用来自C:\的机器配置文件的Windows \ Microsoft.NET \框架\ v4.0.30319 \ CONFIG \ machine.config中 . 日志:尝试下载新的URL文件:/// C:/ Program Files(x86)/ SAP BusinessObjects / Crystal Reports for .NET Framework 4.0 / Common / SAP BusinessObjects Enterprise XI 4.0 / win32_x86 / dotnet1 / crdb_adoplus.dll .

StackTrace:System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName,System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName,String codeBase,Evidence assemblySecurity,RuntimeAssembly locationHint,StackCrawlMark&stackMark,IntPtr pPrivHostBinder,Boolean throwOnFileNotFound,Boolean forIntrospection,Boolean suppressSecurityChecks))字符串codeBase,Evidence assemblySecurity,RuntimeAssembly locationHint,StackCrawlMark&stackMark,IntPtr pPrivHostBinder,Boolean throwOnFileNotFound,Boolean forIntrospection,Boolean suppressSecurityChecks)at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef,Evidence assemblySecurity,RuntimeAssembly reqAssembly,StackCrawlMark&stackMark,IntPtr pPrivHostBinder,Boolean throwOnFileNotFound System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile,Evidence securityEvidence,Byte [] hashValue,AssemblyHashAlgorithm hashAlg,Boolean forIntrospection,Boolean suppressSecurityChecks) orithm,Boolean forIntrospection,Boolean suppressSecurityChecks,StackCrawlMark和stackMark)在CrystalDecisions.ReportAppServer.DataSetConversion.DataSetConverter.DataSetProcessingDelegate(IntPtr arg)的System.Reflection.Assembly.LoadFrom(String assemblyFile)InnerException:


我目前正在使用另一种形式的代码 .

Dim objRpt As New Inv1 Dim invoiceDS As New DataSet

Dim q As String = "select * from inv_data INNER JOIN res_data ON inv_data.inv_res_id = res_data.res_id WHERE inv_res_id = " & EditResID
    GetFromDB(invoiceDS, q)

    objRpt.SetDataSource(invoiceDS.Tables("table"))
    ViewReport.CrystalReportViewer1.ReportSource = objRpt
    ViewReport.CrystalReportViewer1.Refresh()
    ViewReport.Show()

1 回答

  • 6

    尝试将此添加到.config文件(通常是app.config)

    <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
    </startup>
    

相关问题