Crystal Report weird error (Unknown Query Engine Error)

Visual Studio da bazen Unknown Query Engine Error hatası alırız. Özellikle de framework 4.0 ile çalışıyorsak ama hemen kararsızlığa düşmeyin tabi ki bir çözümü var

CrystalDecisions.CrystalReports.Engine.DataSourceException: Unknown Query Engine Error
Error in File C:\Users\Magdy\AppData\Local\Temp\rpt_Stock_Cost {DC276D4F-79F4-43B9-8168-24E6B7BF490A}.rpt:
Unknown Query Engine Error ---> System.Runtime.InteropServices.COMException: Unknown Query Engine Error
Error in File C:\Users\Magdy\AppData\Local\Temp\rpt_Stock_Cost {DC276D4F-79F4-43B9-8168-24E6B7BF490A}.rpt:
Unknown Query Engine Error
   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.ReplaceConnection(Object oldConnection, Object newConnection, Object parameterFields, Object crDBOptionUseDefault)
   at CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type)
   --- End of inner exception stack trace ---
   at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet)
   at Diamonds.UIL.Forms.frm_ReportViewer.Load_Report(String File_FullPath, DataSet DS) in E:\Development\Bitco\Diamond\Project\Diamond 2.0.1\Diamonds\UIL\Reports\Forms\Viewer\frm_ReportViewer.cs:line 256

işte çözüm

Visual Studio içinde bulunan app.config dosyasının içine aşağıdaki kodları yapıştırın ve Rebuild yapın işlem bu kadar :)

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

Error in File C:\Windows\TEMP\ Hatası

Server Error in '/' Application.

---

Error in File C:\Windows\TEMP\ Reports {C754ADDD-2D12-4011-B425-3DF796FA831F}.rpt:
Operation not yet implemented.

 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Error in File C:\Windows\TEMP\RptMasrafListesi {C754ADDD-2D12-4011-B425-3DF796FA831F}.rpt:
Operation not yet implemented.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Aslında çözümü çok kolay

Aşağıdaki güncellemeyi silmek sorunu kökten çözüyor :))

There is one more solution for this problem.

Uninstall Update for Microsoft Windows(KB3102429)

Control Panel –> Program & Features –> View installed updates and Search for KB3102429, right click and uninstall.

This solved my issue.

Crystal Kurulumunda Error 1904 DLL failed to register hatası

Merhabalar;

Crystal Reports kurulumunda eğer " Error 1904. Module C:\Program Files\Common Files\Business Objects\2.7\bin\ExportModeller.dll failed to register.  HRESULT -2147010895. " hatayı alıyorsanız. Çözümü çok basit 

"Microsoft Visual C++ 2005 Redistributable Package (x86)" 

http://www.microsoft.com/en-us/download/confirmation.aspx?id=3387

"Microsoft Visual C++ 2005 Redistributable Package (x64)"

http://www.microsoft.com/en-us/download/details.aspx?id=21254 

kurduğunuzda sorun giderilmiş olacaktır.  

Raporlarda TL yazıyla Kullanımı (Rakamı Yazıya Çevirir)

Crystal Reports'ta Rakam gelen alanları yazıya çevirmek bazen işkence olabiliyor ama bununda kolayı var tabi ki yeni bir formul ekliyorsunuz ve aşağıdaki kodları yapıştırıyorsunuz. Burada tek yapmanız gereken Formul  eklerken Syntax'ı "Crystal Syntax"'tan "Basic Syntax"'a çevirmek olacaktır.

Dim SencerDegisken As Number

Dim SolTaraf As String

Dim SagTaraf As String

Dim SolYuzler As String

Dim SolOnlar As String

Dim SolOnlarbas As String

Dim SolBirler As String

Dim SolDüzeltme As String

Dim SagYuzler As String

Dim SagOnlar As String

Dim SagOnlarbas As String

Dim SagBirler As String

Dim SagDüzeltme As String

SencerDegisken = Sum ({@TOPLAM})