oracle table with timestamp datatype

[Former Member]

Hi,

I have an oracle table with a field of type timestamp.

cannot map this field. The report is empty.

Is there a way to work with timestamps?

Thanks

Otto

[former_member208657 · Accepted solution]

Versions XI R1 or R2 didn't support the Oracle timestamp data type. Check out the following kbase for a bit of info.

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

[Former Member]

thank you for this answer.

[Former Member]

sorry.

I use Oracle Client 10.2.0.3 from Oracle company.

I use Ole Db as database connection.

I use Cr 2008.SP3 Fixpack 3.5

Cannot see the timestamp Field in report designer.

Greetings

Otto

[former_member11696]

info in article:

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

Language: English Version: 2 Validity: 19.11.2009 - active

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

Reproducing the Issue

Crystal Reports XI

Crystal Reports XI R2

Crystal Reports 2008

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, connect to Oracle using the Oracle Native (Oracle Server) connection.

Us the Native Oracle connection in your report.

Don

[former_member11696]

Also, go into [Crystal Report Forum|; and search on "timestamp"

You'll find lots of help on how to. Also, If the designer doesn't allow you to browse or it doesn't show the field then either the DB driver you are using on the Client PC doesn't support it or CR is not aware of the field type for your database.

As Ludek indicated, need a lot more info...

Thank you

Don

[former_member183750]

Otto, you should know from your previous posts that you are pretty slim on details here. From your previous posts, you should also know what info is important to provide. If not, see the following:

http://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement

/people/ludek.uher/blog/2008/11/24/what-do-i-need-to-do-to-get-the-fastest-issue-resolution

- Ludek