- Fields of data type “Date Time” appears as text.
- Date Time characteristic displays as string in Crystal Reports.
- When reporting off an SAP BW BEx Query that contains characteristic of data type: "Date Time", it displays as string in Crystal Reports.
- Crystal Reports 2008
- SAP Crystal Reports 2011
Reproducing the Issue
In BEx Query Designer, create a BEx Query containing a characteristic of data type date time.
In Crystal Reports, create a new report off the BEx Query using the "SAP BW MDX Query" connection.
In the "Field Explorer" , notice the data type of the characteristic that contains a date time is displayed in a string.
- This is normal behavior. SAP BW BEx Query characteristics of data type: Date Time, will be displayed in a string format in Crystal Reports.
data type, date time, string, CR 2011, datatype, object, characteristic, sap, bex, bw, sap, CR2011, ADAPT01636481, 1636481 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03