Specific Sorting by common beginnings

[walshut]

I am trying to sort my report in a specified order. I am dealing with unique asset numbers and need them to show up on the report in a specific order. Example:

First #'s... (1234-9999)
then all numbers with a "0S" in front (0S1234-0S9999)
then all numbers with a "0X" in front (0X1234-0X9999)
then all numbers with a "S" in front (S01234-S9999)
then all numbers with a "X" in front (X01234-X9999)

By sorting the report by ascending or descending I can not achieve my desired order. So I have been attempting at using specified order. But the limitation here is that I can not select:

first (all integers)
first all numbers with (all starting with "0S&quot
first all numbers with (all starting with "0X&quot
first all numbers with (all starting with "S&quot
first all numbers with (all starting with "X&quot

The only way I see that I can use specified sort is to pick each number in the order that I need. Is there a way to pick by commonalities?

Any other suggestions?

 

[Ngolem]

try grouping on this formula

I'll assume this is a one field and it is a string

@grouping

if isnumeric(left({Table.value},1)) then
"1"
else if Left(left({Table.value},2) = "OS" then
"2"
else if Left(left({Table.value},2) = "OX" then
"3"
else if Left(left({Table.value},2) = "S" then
"4"
else if Left(left({Table.value},2) = "X" then
"5"
else
"6"; // a catch-all in case there other formats

hope this works for you

Jim
JimBroadbent@hotmail.com

 

[kridg]

I've used the specified sort with dates since our database stores them as YYYYMMDD. I want list files by their date in decending order. Using the specified order, I create a group named "Year 2001" and the criteria is that DATE "startswith" 2001.

 

[kenhamady]

You select all integers by doing an "is between" 0 and 9 for your first group. With text, saying between 0 and 9 is the same as saying starts with any integer. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com