report displays date field on server as timestamp, despite format

[Former Member]

I formatted a date field in my report as 01/03/2009.

This looks ok when testing in Crystal Reports.

On the server the date displays as 01/03/2009 12:00:00 AM.

I really want to get rid of the time, as it doesn't fit in the report.

I noticed that in an older report the field of the same date is typed as timestamp. In this case the server display correctly.

The problem is, I cannot figure out how/why the date is typed differently in the 2 reports, e.g. date vs timestamp.

Help!?

[Former Member]

@Don,

I am connecting to an Oracle DB (EMC Documentum) through JDBC.

[former_member11696]

Ah, that explains it. Some JDBC drivers handle date field types differently.

Be sure you are using the latest JDBC jars from Oracle and make sure you have the correct Java path in the PATH statement.

Other than that it is likely a limitation of the driver itself.

Try using the native Oracle driver in the database wizard and see if you get the same results.

And as suggested go into the Report Options and see if any of the those switches help. Also right click on the field and select Format and see if those option also help you.

Thank you

Don

[Former Member]

@Debi,

I suppose you mean changing the datetime field in the general options (as in the report options I cannot find how).

I already did that, my datetime is set to "01/03/2009". It doesn't seem to make a difference.

[Former Member]

You can set the datetime field to a date field in report options. Course this would convert all datetime fields to a date in the report.

[former_member11696]

Hello,

CR dynamically accesses the database so each may/could be different.

Need to know what DB you are connecting to and how?

Thank you

Don