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

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

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

Header Data

Released On	19.03.2015 20:45:03
Release Status	Released to Customer
Component	BI-RA-CR Crystal Reports designer or BusinessViews Manager
Priority	Normal
Category	Problem
Database	ORACLE 11.0