3171274 - Error: "Failed to retrieve data from the database... Incorrect syntax near ','..." when refreshing a report based on a Command Object with a multiple values parameter in Crystal Reports

Error: Incorrect syntax near ','
When entering multiple values in a parameter, the report generates an error.
When entering only one value in a multiple values parameter, the report refresh successfully.
When refreshing a report based on a Command Object to MS SQL Server, and entering multiple values, Crystal Reports generate error like:

"Failed to retieve data from the database.

Database Connector Error: '42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]
Incorrect syntax near ','. [Database Vendor Code: 102]' "

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.