Symptom
- 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.
Read more...
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- MS SQL Server 2012
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2017
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016
Keywords
CR, Time(0) , 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.