Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Can Grow Greyed Out for Date Field Post Reply Post New Topic
Author Message
Grifter
Newbie
Newbie


Joined: 02 Jun 2009
Online Status: Offline
Posts: 32
Quote Grifter Replybullet Topic: Can Grow Greyed Out for Date Field
     Posted: 22 Feb 2010 at 5:52am
Hi

I have a date field that displays date/time and would like the field to grow to show date on top line and time on next line. Can grow is greyed out for the date field.

My understanding is that you can only grow string type fields and tried following advice from elsewhere to put data field in a text box then set can grow. I can't see how that would work as the date field is inside the text box and will still not grow?

However on doing this I kept getting an error with CR and had to close. There must be another way of setting this up to split the date and time?

Thanks

Andrew
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 22 Feb 2010 at 7:11am

if I was going to put a date field in a text box, I would probably use a formula to display it. Something like totext({table.field}, "MM/dd/yyyy hh:mm:ss").   You might try added a CRLF into the formatting field to force it 2 lines or 2 formulas 1 like: totext({table.field}, "MM/dd/yyyy") and the other like totext({table.field}, "hh:mm:ss")  thereby creating your own display

OR forget the formula, just display the same field 2 times, once formatted to display the date, and the other to display the time.
 
HTH
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum