Windows server 2012 R2 SetDataSource doesn't work

[Former Member]

When I call ExportToDisk(). In some machine do well. But in window server 2012 R2 throw the exception.

Exceptoion

This field name is not known. Error in File C:\Windows\TEMP\RPTH010_Report01 {C0D0E863-1741-4917-A455-B23347EA4FD6}.rpt: Error in formula <填單日期>. 'numberVar RocDateNumber := {RPTH010_Report01.D01_APLDATE};' This field name is not known.
This field name is not known. Error in File C:\Windows\TEMP\RPTH010_Report01 {C0D0E863-1741-4917-A455-B23347EA4FD6}.rpt: Error in formula <填單日期>. 'numberVar RocDateNumber := {RPTH010_Report01.D01_APLDATE};' This field name is not known.

Stack trace

CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToDisk(ExportFormatType formatType, String fileName) JcsWebSolution.Report.CRDocument.SaveToDisk() mOffice.Models.Report.ASSET.RPTH010_Report01.PrintReport() mOffice.Models.Report.ReportBase.PrintProcess()

My system

• CrystalDecisions.CrystalReports.Engine.dll, v10.5.3700.0
• CrystalDecisions.Shared.dll, v10.5.3700.0
• Window Server 2012 R2
• Visual Studio 2013

After that I test a new report which have 3 records without formula. I find that the report can export, but does not show records. So I guess the main reason is that SetDataSource() doesn't work in my machine(windows 2012 R2).

I try to add the code to Web.config. But It still does not show records. Does anyone know about this problem?

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

[former_member188030 · Accepted solution]

Hi Tony,

CR 10.5 (CR for VS 2008) is not compatible / tested supported with Win 2012. It is also not compatible with VS 2013.

Upgrade CR to CR for VS 2013 (13.0).

http://scn.sap.com/docs/DOC-7824

Thanks,

Bhushan

[former_member183750]

Hi Tony

Please do follow Bhushan's advice. And(!), do make sure you uninstall CR 10.5 as CRVS and CR 10.5 do not play nice on the same dev computer. Runtime computers are fine.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Hi Ludek:

I follow Bhushan's advice. I remove all CRVS of the dev. And I install the CRforVS_13_0_10.exe in my dev. Because I find some article said sp13 have a trouble with the message "cannot find the path specified".
When I try to export the report I get a new error with "Fail to load database information". Because report just using field define(TTX) design.

Exception information

無法載入資料庫資訊。檔案 RPTH040_Report01 {3EDB667C-8692-45E6-84B2-418720F41CE3}.rpt 錯誤:無法載入資料庫資訊。

Stack Trace

CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToDisk(ExportFormatType formatType, String fileName)
JcsWebSolution.Report.CRDocument.SaveToDisk() 於 d:\Project\mOfficeDemo\mOffice\Models\Report\CRDocument.cs: 行 316
mOffice.Models.Report.ASSET.RPTH040_Report01.PrintReport() 於 d:\Project\mOfficeDemo\mOffice\Models\Report\RPT\ASSET\RPTH040_Report01.cs: 行 243
mOffice.Models.Report.ReportBase.PrintProcess() 於 d:\Project\mOfficeDemo\mOffice\Models\Report\ReportBase.cs: 行 119

I try to troubleshoot with this link http://scn.sap.com/thread/1834001.

I find that crdb_cdo.dll and crdb_fielddef.dll are both in the folder(C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86). But it still show the error. How could I fixed it?

After that I uninstall SP10 & install SP12. The error message change to "cannot find the path specified".

Exception information

系統找不到指定的路徑。

Stack Trace

CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)
CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)
mOffice.Areas.ASSET.Controllers.RPTController.test1234() 於 d:\Project\mOfficeDemo\mOffice\Areas\ASSET\Controllers\RPTController.cs: 行 55

[former_member183750]

Hi Tony

If you are using datasets, please see KBA 1525432 (search box in top right corner) and see if that helps.

- Ludek

[Former Member]

Hi Ludek & Bhushan:

Thank you all, it is useful to me. And the report work well right now.

Thanks a lot.
Tony