Print Page | Close Window

Sort order for special characters

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12653
Printed Date: 03 May 2024 at 10:14pm


Topic: Sort order for special characters
Posted By: joeyg13
Subject: Sort order for special characters
Date 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?


Replies:
Posted By: DBlank
Date 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}

Posted By: joeyg13
Date 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.

Posted By: Ryan J.
Date 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??


Print Page | Close Window