SAP Knowledge Base Article - Preview

2608622 - MS SQL Server Date fields or Stored Procedure Date Parameters, shows as text in Crystal Reports

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.