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.
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.