Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

Crystal Compatibility and Sage 100

April 10, 2018 by Wayne Schulz

Have you recently started an upgrade from an earlier version of Sage 100 to Sage 100cloud or Sage 100 version 2018 and run into this Crystal Reporting error?

 

Crystal Report Windows Forms Viewer

“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 for the interface with IID ‘{98CDE168-C1BF-4179-BE4C-F2CFA7CB8398}’ Failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Here’s the reason that you are encountering the error and the way to fix it.

Example: Sage 100 or Sage 100cloud STANDARD upgrade from 2016 to 2018

  1. Install 2018 to SERVER
  2. Run 2018 workstation setup on a WORKSTATION which also has 2016 installed
  3. This breaks Crystal Printing on that 2018 workstation (at this point 2016 workstations can still print)
  4. To fix the 2018 printing, copy the Pvxwin32.exe.Config file from the 2018 SERVER “..\MAS90\Home” directory where Sage 100 2018 is installed, into the 2016 SERVER “..\MAS90\Home” directory of the previous version(s) where the error is experienced.
  5. The issue resolves for 2018 TEST WORKSTATION – BUT …
  6. However, because you copied the config files to the 2016 folder you break printing for 2016 LIVE WORKSTATIONS NOT YET UPGRADED WITH 2018 WKSETUP
  7. Unless those 2016 LIVE WORKSTATIONS (a) also install 2018 WKSETUP (or presumably you remove the Pvxwin32.exe.Config from above which breaks your 2018 workstation but lets 2016 without 2018 installed print ) AND you’ve moved the config described in (4) above.

Business Issue:

  • Generally not a big issue if you are doing an upgrade in one day because you can uninstall 2016 and install 2018 wksetup and everyone can print
  • The problem appears when a customer wants to test over the course of several days/weeks and wants to run 2016 and 2018 on the same workstation(s) in a production environment.
  • You can’t just give one person 2018 wksetup (and move the config to the 2016 folder) without doing the whole company or the fix above breaks the 2016 people who don’t have 2018 wksetup
  • While this may not seem like a huge issue it is problematic in large installs with 20+ user counts, shipping, receiving because of the time it takes to travel from workstation to workstation and debug minor issues,

Possible workaround on this would be:

  • Install 2018 for testing to a standalone workstation that is not used for any prior version
  • Test on this workstation that has no other Sage version(s)
  • When ready run wksetup on remaining workstations and remove prior Sage version
  • The issue with this workaround is other users can’t test various workstation issue such as printing, credit cards, etc

The Sage KB entry which more fully describes the resolution can be read online at – Error: “Unable to cast COM object of type” when printing in prior Sage 100 versions after installing Sage 100 2018

Filed Under: Sage 100 ERP, Sage 100c Tagged With: crystal 2011, crystal 2016, Crystal Reports, sage 100, sage 100cloud, upgrade

Search Our Site

Sage 100cloud Latest News

  • WFH Tip For Sage 100: Go Paperless February 24, 2021
  • When is Sage 100 2021 Due for Release? February 19, 2021
  • Sage 100 Partner Cloud List of Supported ISVs as of January 2021 February 12, 2021
  • Sage 100 User Help Files and Table Layouts – Version 2018 – 2020 January 27, 2021
  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in