Crystal Reports Blank Spaces in Date Ranges

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

Topic: Blank Spaces in Date Ranges

Author	Message
coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Topic: Blank Spaces in Date Ranges Posted: 22 Jul 2013 at 9:53am
	I am running a Crystal Report and exporting it to a CSV file. In my date fields there are blank spaces before and after the date range. Is there a way to remove these spaces? ex: DATA, 04/01/2013 02:28:37 , 05/15/2013 14:10:26 ,DATA
	IP Logged

praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 22 Jul 2013 at 10:41am
	Use Trim Function to remove Leading and trailing spaces from database field. Trim({Database filed})
	Praveen Guntuka, praveen_guntuka@yahoo.com
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 22 Jul 2013 at 10:47am
	Can I use the TRIM function in Crystal, if so how would I do it? Thanks,
	IP Logged

praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 22 Jul 2013 at 10:52am
	You can use Trim function in crystal. Crate a fromula in designer as Trim({Database Field}) Remove the date field from the report and place the fromula field. Then export the report to .CSV format
	Praveen Guntuka, praveen_guntuka@yahoo.com
	IP Logged

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