INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Just wanted to let you know that I registered today, and your site is fantastic. I found solutions to problems that I have been encountering for months!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 4 Other topics Forum

Changing Dates

Read More Threads Like This One

Smithsc (MIS)

19 Jul 12 10:19

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 (Programmer)

20 Jul 12 6:14

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.

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

Smithsc (MIS)

20 Jul 12 6:16

Thanks for the tip.

Does anyone know why this is happening?

IanWaterman (Programmer)

23 Jul 12 7:13

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 (Programmer)

24 Jul 12 10:45

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.

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 4 Other topics