Crystal Reports Making Date Field Grow

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Making Date Field Grow

Author	Message
jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Topic: Making Date Field Grow Posted: 28 Jul 2010 at 9:32am
	What's an easy way to make a 'Date' field expand to an additional line. The 'Can Grow' checkbox is grayed out.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Jul 2010 at 10:38am
	do you mean you want it to wrap?
	IP Logged

rameshcrystal Newbie Joined: 27 Jul 2010 Location: India Online Status: Offline Posts: 9	Posted: 28 Jul 2010 at 9:07pm
	i am not sure,You should do reduce size of the text object in that field. i will print next line.
	IP Logged

jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Posted: 29 Jul 2010 at 2:54am
	yes, I would like it to wrap. Is there a reason why the 'Can Grow' tab is grayed out? Edited by jgarner - 29 Jul 2010 at 3:38am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jul 2010 at 3:38am
	Use a formula to convert it to a string then set the width as you want with 'can grow' set to True on the formula field.. totext(date) or if you want it to wrap at a specific place include that in your formula field. if you need help writing that post an example of the field and your desired result.
	IP Logged

jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Posted: 29 Jul 2010 at 3:42am
	Since I can't resize the other fields in the report to make the date fit, I need the date to look like this: 10/20/ 2010 I would like the year to be on a separate line.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jul 2010 at 3:59am
	totext({table.DATE},'MM/dd/'+CHR(13)+'yyyy')
	IP Logged

jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Posted: 29 Jul 2010 at 4:10am
	I'm really confused how the 'CHR(13)' fits into the formula, but it worked as suggested. Thank you.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jul 2010 at 4:17am
	CHR(13) is just the character for a carriage return. It is a very handy thing to remember
	IP Logged

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