Changing Dates

[Smithsc]

I've got a crystal report (2008 version) written which comes from an Oracle 11g database. This report contains many fields 2 of which are dates.
When I run the report for a small number of records (100-) the date fields show as the correct date. When I run the report for a large amount of records (66,000+) all the dates show as 30-Dec-99. When I export the large report to an excel spreadsheet the all the dates show as 00-Jan-00.

I have tried exporting with and without the object formatting but neither option works.

Does anyone have any ideas what's happening.

Thanks

Stuart.

 

[Madawc]

As a work-round, try using ToText to format the date in the form you want it. I've done this to avoid problems with different defaults on different machines.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Smithsc]

Thanks for the tip.

Does anyone know why this is happening?

 

[IanWaterman]

What is yor report doing?

Is it grouping by date or summarising dates.

In File -> Report -> Options have you checked convert Database nulls to default.

If could be with small number of records no nulls are encountered but for a large data set they are turning up and affecting your results.

Try running the report SQL in Toad or SQL developer directly on database and see what data is returned for dates in there.

Ian

 

[Madawc]

If you look at Files > Options and choose the Fields tab, you find that Crystal allows you to choose a default. But the same software on someone else's machine may have different defaults and run differently.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP