x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 4 replies
  • Subscribers 119 subscribers
  • Views 467 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
dhalpin

Sage alerts w/crystal reports error

Posted By

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.

*Community Hub is the new name for Sage City