Crystal Reports sort by negative string

Technical Questions

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

Topic: sort by negative string

Post Reply

Post New Topic

Author	Message
huyenhall Newbie Joined: 07 Apr 2008 Online Status: Offline Posts: 7	Topic: sort by negative string Posted: 07 Apr 2008 at 2:33pm
	Could someone help me to sort a string field that has negative number? For example if sorted by decs the report should look like this: 0 0 156 123 100 -34 -289 -869 and so on....
	IP Logged


Iago Groupie Joined: 01 Oct 2007 Location: United States Online Status: Offline Posts: 52	Posted: 15 Apr 2008 at 1:02pm
	use a formual and convert to a number, then sort by the formula If NumericText ({file.FIELD}) Then ToNumber ({file.FIELD}) Else 0
	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