Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Topic: Sort order for special characters Posted: 18 Mar 2011 at 8:16am
Having trouble trying to force a group to the bottom of my report. I have tried several special characters (like tilde ~), but Crystal sorts to top of list. For instance, I have a field with names, but sometimes "Unassigned", and I want Unassigned at end. But, I have people with names after 'U'.
Also, appears Crystal does not consider capitalization (A with a).
1) Maybe a switch/setting I can adjust? 2) Is there something I can prepend to data for group/sort?
Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Posted: 23 Mar 2011 at 9:49am
Thanks. Using a space character is the solution I finally came to also. Just weird that A and a sort together, and special characters like ~ or ^ did not help.
Joined: 06 Aug 2010
Online Status: Offline
Posts: 1
Posted: 06 Sep 2011 at 5:35am
I'm using Crystal Reports 2008 SP3 and spaces are sorting to the top along with most other special characters. I can't find anything that will sort to the bottom! Any suggestions??
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