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 22.214.171.1241) 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?