Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Sort order for special characters Post Reply Post New Topic
Author Message
joeyg13
Newbie
Newbie
Avatar

Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Quote joeyg13 Replybullet 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?

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Mar 2011 at 3:48am

use a formula field to convert the data and then group on the formula field

have the formula field throw a " " in front of all the regula names
 
if {table.name}='unknown' then {table.name} else " " + {table.name}


Edited by DBlank - 21 Mar 2011 at 3:51am
IP IP Logged
joeyg13
Newbie
Newbie
Avatar

Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Quote joeyg13 Replybullet 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.
IP IP Logged
Ryan J.
Newbie
Newbie
Avatar

Joined: 06 Aug 2010
Online Status: Offline
Posts: 1
Quote Ryan J. Replybullet 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??
IP 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.