Crystal Reports Changing Date Format to View

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Changing Date Format to View
	<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 07 Apr 2011 at 3:40am
	In the Crosstab row headers or somewhere else in the report? Edited by DBlank - 07 Apr 2011 at 3:41am
	IP Logged

chris.wolf Newbie Joined: 01 Apr 2011 Online Status: Offline Posts: 9	Posted: 11 Apr 2011 at 4:09am
	Hi, Ok managed to get the carriage return to happen but the formatting is now screwed up again. Under culumn group options on cross-tab expert. The formula I have used to insert the carriage return is - Date({POPOrderReturn.DocumentDate}) & CHR(13) & Date({POPOrderReturn.DocumentDate}) It shows the date as DD/MM/YYYY on both lines how do I get it to accept the formatting that you suggested to me before? Many thanks, Chris.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Apr 2011 at 4:36am
	Not sure where you are at with this. The carriage return is tricky. As far as I know you cannot break a line in a date field type and maintain the characteristics of a date field.
	IP Logged

chris.wolf Newbie Joined: 01 Apr 2011 Online Status: Offline Posts: 9	Posted: 12 Apr 2011 at 4:59am
	Hiya, I managed to get it working with the following formula in the group options. ToText({POPOrderReturn.DocumentDate}, "yyyy") & CHR(13) & ToText({POPOrderReturn.DocumentDate}, "MMM") Many thanks for your help on this subject. Regards, Chris Wolf.
	IP Logged

<< Prev Page of 2

Post Reply

Post New Topic

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

This page was generated in 0.031 seconds.