Symptom
- MS SQL Server date shows as text field.
- SQL Server date field displays as string data type in Crystal Reports.
- MS SQL Server Stored Procedure Date Parameter, prompt as a String Parameter in Crystal Reports.
- On one computer, the date fields shows as date, but on another computer the date fields shows as string.
- When refreshing a report on one computer, it refresh successfully, but on another one, it generates error in formula because the data type changed from a Date to a String.
Read more...
Environment
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- SAP Crystal Reports 2025
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2017
- MS SQL Server 2019
Product
SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025
Keywords
CR, CRDB , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.