Hi Katy,
 
You want to sort on the sortnumber field rather than the objectnumber field.
 
Jeri

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Katy Rawdon-Faucett
Sent: Friday, January 19, 2007 3:26 PM
To: [log in to unmask]
Subject: Crystal Reports question

Hi all,

 

I have a Crystal Reports question regarding the sort-order for reports sorted by object number. CR seems to sort in “computer speak,” i.e. 10 comes after 1, 20 comes after 2, etc. Is there any way to get around this, so that a report can be sorted by real number order? Please contact me off-list if you would prefer.

 

Thanks,

Katy

 

 

____________________
Katy Rawdon-Faucett
Archivist and Librarian
The Barnes Foundation
300 North Latch's Lane
Merion, PA  19066-1759
Ph:  (610) 667-0290 ext. 1048
Fax: (610) 664-4026
[log in to unmask]
www.barnesfoundation.org/archives.html