- Time(0) displays as string.
- When modifying the SQL Query of a report, the data type of some field changes from Time to String.
- When creating a report of MS SQL Server, and entering a SQL Query that cast data as time with Time(0), it displays as a string in Crystal Reports, instead of Time.
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- MS SQL Server 2012
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2017
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016
CR, Time(0) , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.