Crystal Reports natural sort

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

Topic: natural sort

Author	Message
kev921hs Newbie Joined: 30 Oct 2007 Online Status: Offline Posts: 6	Topic: natural sort Posted: 02 Nov 2007 at 8:45am
	Hi All - I have a report that I want to use a natural sort on, that is, NY11 ... NY108 NY109 NY110 instead of NY108 NY109 NY11 NY110 Is there a way to accomplish this in CR? I've considered writing some custom sorting formula to handle it but that could get ugly, and I'm hoping for an easier solution...
	IP Logged

IdoMillet Groupie Joined: 26 Oct 2007 Location: United States Online Status: Offline Posts: 99	Posted: 02 Nov 2007 at 10:23am
	Create formula such as: Picture({your_field}, "xxxxxxxxxxxxxx__________") Sort on that formula.
	view, e-mail, export, burst, distribute, and schedule Crystal Reports. www.MilletSoftware.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.031 seconds.