Crystal Reports How to do Left Trim

Report Design

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

Topic: How to do Left Trim

Author	Message
eeps24 Newbie Joined: 23 Jul 2015 Online Status: Offline Posts: 3	Topic: How to do Left Trim Posted: 04 Aug 2015 at 3:11am
	I am new to crystal, can someone walk me through on how to do a left trim to a field I have in crystal? Thank you
	IP Logged


kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 04 Aug 2015 at 5:38am
	ltrim({stringfield})
	IP Logged

eeps24 Newbie Joined: 23 Jul 2015 Online Status: Offline Posts: 3	Posted: 04 Aug 2015 at 8:52am
	im going to ask a stupid question. Can you please tell me where I can do this? When I right click on my field? what do I select to get to where I have to go? thank you so much.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 04 Aug 2015 at 12:47pm
	You have to make a formula and put the code there. And of course use the formula in the report. Edited by kevlray - 04 Aug 2015 at 12:47pm
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 05 Aug 2015 at 3:46am
	to help clarify kevlray's solution, you are not altering the original data which I think you may be expecting. You are creating a formula field that you are filling with the trimmed value. The original field remains untouched. Crystal does not change values in the source data.
	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