VS 2022 crashing when building Crystal Report with Parameters from Database Expert

[tijani78]

Hello,

I have a stored procedure with parameters when I try to build a report based on this SP, a dialog box "Enter values" is displayed and few seconds after clinking on the ''OK'' button, VS crashes.

I have installed SP32 and I'm using VS Professional 2022 (64-bit) - Version 17.1.0

Installed packages :

SAP Crystal Reports runtime engine for .NET Framework (32-bit)

SAP Crystal Reports runtime engine for .NET Framework (64-bit)

SAP Crystal Reports, version for Microsoft Visual Studio (64-bit)

Could you help me to solve this issue?

Many Thanks

Regards

[DellSC]

Did you install the runtimes separately or were they part of the SP32 install?

[tijani78]

Thank you for your quick reply. 🙂

I installed it separately

[tomas-jurksas92]

No one version of SAP didn't work with VS2022, you must install VS2019 if you want to build report. All the time VS crashes when you are trying to preview, verify database, run db expert and so on.

[former_member11696 · Accepted solution]

SAP Crystal Reports, version for Microsoft Visual Studio (64-bit) installs the MSI package so uninstall the x86 and x64 MSI packages and then repair the EXE install. It should prompt you if you want the 32 bit MSI installed.

Also required is when you install is to right click on the EXE and select Run As Administrator.

Are you using the Embedded Report Designer built into VS?

It's a new version, 64 bit, so there have been a few issues reported.

I'll give it a quick test and see if I get the same issue.

Need more details first:

What Database Server are you connecting to?

What Client are you using?

ODBC, OLE DB, Java client or Native?

What type of SP Parameter are you using?

Don

[tijani78]

Thanks a lot everybody, it works now.

I uninstalled everything and installed only SP 32 for VS 2022 with 32 bit it suggest at the end of the installation.

Now I just have an issue to set the parameters, I get this exception.

CrystalDecisions.CrystalReports.Engine.ParameterFieldCurrentValueException: 'Missing parameter values.'

Regards

[tijani78]

Thanks for your response.

I'm going try a complete re-install of Crystal Report and try again.

It's a SQL Server database.

OLE DB client.

I'm using int, nvarchar and bigint

Tijani