Sage alerts w/crystal reports error

I am trying to attach a crystal report to a Sage Alert. I have crystal reports installed on the Sage Alerts server and Sage 100 workstation installed as well. I have the SAP Crystal runtime engine for .NET framework 64 bit installed as well. The alert cannot generate the report. It is giving crystal reports the type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception..Do I need the 32 bit runtime installed as well? I originally had that installed along with the 64 bit runtime but was receiving this error below so I uninstalled it and crystal and reinstalled crystal again.

Unable to cast COM object of type 'CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass' to interface type 'CrystalDecisions.ReportAppServer.Controllers.ISCRReportSource'. This operation failed because the QueryInterface call on the COM component

Looking for any advice. Thank you!

  • 0

    Are you running Standard, Advanced or Premium? Don't know about Premium, but for Standard and Advanced, you need to use the Access Database created with the KLF as your datasource.

  • 0 in reply to suzmwatson

    Running advanced and yes I have access database already linked with KLF. This is not a new install. Sage Alerts v10 has in use for quite some time now but just not the report generation piece.

  • 0 in reply to dhalpin

    So are you using the access database as your datasource in your crystal report.

  • 0

    Sounds like SAW isn't using the correct Crystal version when it tries to generate the report. When you install SAW it looks to see if you already have crystal installed and then if it is the version it needs. If it is then it continues. If it isn't then it uses its version of the crystal reports. If you installed a different version since you first installed SAW it will not realize this and continue to use what it thought was the right one. You may need to first make sure that crystal is working with whatever app installed it. If it isn't then get that to work. Then reinstall SAW (make sure it is the most current version). Once you reinstall, reboot. Then try to run SAW to generate the report.