Fetching SQL statements is not supported for this report. (997) with ODBC driver 13 for SQL server

[former_member927769]

Hi Team,

I am getting a very weird behavior with ODBC driver 13 for SQL Server however everything works fine with ODBC driver 11 for SQL Server. We are using ODBC connection for our report.

sql = Me.RowsetController.GetSQLStatement(New DataDefModel.GroupPath)

The above statement throws "Fetching SQL statements" error with ODBC Driver13 on printing report criteria. However print report criteria works fine with ODBC Driver 11 for SQL Server. Although nothing has changed other than driver in the registry ODBC DSN.

We are using Visual Studio 2019 with .NET framework 4.8. Also we are using Crystal Report Runtime 13 support pack 10 with version 13.0.10.1385

Could someone from SAP suggest how to resolve this behavior. We are not able to upgrade to ODBC Driver 13,17 or 18 ?

[lenastodal]

Welcome to the SAP Community! We're glad you've come here to get answers to your questions. Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.
You should also make sure your e-mail notifications are turned on for "Comments and answers to my questions and questions I follow" at #communications -- so you won't miss any replies to your question.
In addition, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.
I hope you find this advice useful, and please let me know if you require any additional guidance!