SAP Knowledge Base Article - Public

1206647 - Does Crystal Reports support Oracle TIMESTAMP data type fields?

Symptom

  • Oracle Timestamp data type fields displays as picture in Crystal Reports.
  • Oracle Timestamp data type fields doesn't display in Crystal Reports.
  • Oracle Timestamp data type fields doesn't work in Crystal Reports.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off an Oracle data source using an ODBC or OLEDB connection.
  2. Notice the database field that have a Timestamp data type in Oracle displays as a picture data type in Crystal Reports, and it does not return data for the field.

Cause

  • Crystal Reports doesn't supports the following Oracle data type:
    • Timestamp
    • Timestamp with time zone
    • Timestamp with local time zone
           
  • When connecting to Oracle using the following connections:
    • ODBC
    • OLEDB

Resolution

  • To report from Oracle timestamp data type fields in Crystal Reports, connect to Oracle using the Oracle Native (Oracle Server) connection:
       
    1. In Crystal Reports, under the menu "File", select "New - Blank Report..."
    2. In the "Database Expert" window, expand "Create New Connection"
    3. Under "Create New Connection", select "Oracle Server"
    4. Select the Oracle server to connect to.

Keywords

ORACLE TIMESTAMP DATETIME FIELD TIME ZONE NATIVE ODBC OLEDB CONNECTION stamp ole db connect date time RDO ADO , 9231146 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016