Crystal 2008 with Oracle Time stamps

34 Views

We have a need to convert some of our Oracle date fields to timestamps to obtain better accuracy, These fields appear on a large number of Crysal Reports in our system. Initial testing shows that the CR 2008 client (version 12.3.0.601) cannot read a timestamp from the database.

I have seen the 1206647 application note and it doesn't seem to tbe correct. When using Oracle Server on the PC I can see the time stamp field but it is labeled as a 'String', Attempts to preview on the PC fail with a database connection error, even when using Oracle Server.

I can run the report on the Linux server using the Java Crystal Reports engine but the time stamp field is blank.

Is there a patch or an updated version of CR which natively supports Oracle Time Stamp fields?