SAP CRYSTAL REPORT 2020 support ODBC DRIVER 18 FOR SQL SERVER?

[Srividya]

In our product, we have many crystal reports which are designed to fetch data using MS SQL stored procedure, it is getting launched successfully, when we use the ODBC Driver SQL Server, and while upgrading the MS SQL ODBC driver to "ODBC driver 18 for SQL Server", we are facing the below problem in SAP crystal report processing. 

05/02/2024 4:32:52 PM The table 'R_ADT_ADM001' could not be found. Error in File ADM002 5356_10864_{D00DEF7A-1D90-4C60-84AE-C2061BB38337}.rpt: The table could not be found. (-2147482939)

We are currently using the SAP crystal report run time "CRRuntime_32bit_13_0_15.msi" to invoke the report. 

On further analysis, when we open the Crystal Reports using the SAP Crystal Report 2020 and Set Datasource Location selected the Report ‘R_ADT_ADM007’ linked with Stored procedure are unable to open in the Sap crystal report, it prompts a Message “Data Object Cannot be opened/accessed”.

Kindly review and let us know any configuration we missed out or is the ODBC driver 18 for SQL Server supported.

[DonWilliams]

Currently MS SQL Server 2022 is not supported:

Supported Platforms

[SureshBala]

Hello DonWilliams, Could you please inform us if there's any estimated timeframe in SAP Crystal Reports for the inclusion of support for MS SQL Server 2022 / MS ODBC driver 18 for SQL Server?

[DonWilliams]

I see it's supported in CR 2020 SP 4 now, update CR 2020 and it will be supported Patch 300 - https://origin.softwaredownloads.sap.com/public/site/index.html

[mhotze]

Any plans to put this into SAP Crystal Reports, developer version for Microsoft Visual Studio?

[DonWilliams]

Check the supported platforms for updated info, CR 2020 is supported so CR for VS should be in SP 36 due out in a month or so: https://www.sap.com/documents/2020/06/b2ec5eaa-9d7d-0010-87a3-c30de2ffd8ff.html