SAP Knowledge Base Article - Public

2879597 - Missing Calendar icon on Date parameter prompt in Crystal Reports


  • report of SQL Server returns incorrect data
  • SQL Server date fields not mapped properly when Set Datasource Location to a different ODBC driver
  • date parameter prompt does not have Calendar icon on it


  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SQL Server database


Incorrect "SQL Server" ODBC driver driver used. The driver is not supported by the vendor, see:


Use supported ODBC Driver like DataDirect ODBC driver or "SQL Native Client 11.0" driver. See Supported Platform documentation.

See Also

1338845 - How to find Product Availability Matrix (PAM) / Supported Platforms Documentation for SAP BusinessObjects products


ODBC, DateTime, wrong results, failed, error , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016