SAP Knowledge Base Article - Public

3235319 - Crystal Reports for Visual Studio SP 32 - Visual Studio 2022 Embedded Report Designer selecting ADO.NET data source dll does not accept access to ClassPath

Symptom

Open an existing Web Site project won't allow you to get past the ClassPath UI.

Environment

  • Crystal Reports for Visual Studio SP 32
  • Visual Studio 2019
  • Visual Studio 2022

Reproducing the Issue

Open an existing project and using the Embedded Report Designer and select ADO.NET

Fill in the ClassPath and it fails to find it.

Resolution

  1. If it’s a Web Application project(from menu File->New->Project, Web->ASP .NET Web Application), there will be no problem opening it in VS2022, report could work well with Project Data->.Net Objects in embedded CR designer.
  2. If it’s a Web Site project(from menu File->New->Web Site, ASP.NET Web Site), then it will be a problem in VS2022.

R&D results:

There are some types and functions(which are defined in the LIBs for .NET Framework and used in our LIB(crdb_adoplus.dll), the error is reported as "System.MissingMethodException: Method not found " when opening the project with VS2022.

R&D checked the IDE in VS2022 and VS2019 and found that the LIB(mscorlib.dll in C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.8) will be loaded when opening a web site project with VS2019, it never gets loaded by VS2022.

The issue is about VS2022 or .net framework, DLLs in .net framework can't be loaded by VS2022, that is why it will report the error "System.MissingMethodException: Method not found ".

CR for VS can't create a web site project with VS2022 now.

This appears to be a limitation when creating/using a web site project in VS2022.

Nothing we can do about this limitation, Microsoft will need to fix it.

As a work around use a ful version of Crystal Reports to update the connection info or design a new report.

Note: the Embedded Report Designer is very old technology and only included for simple tests, if issues are found use the full version of CR Designer or run the application to verify it's working.

Keywords

cr for vs, classpath, vs 2022, vs 2019, ado.net, Web Site , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

Product

SAP Crystal Reports, version for Visual Studio all versions