Specifying a non-alphabeticaly sort order for text-values in repor

[Guest]

I have made a report in witch i group by 3 fields: A, B
Each of these groups only have finitely many text-values, lets say
A_1,A_2,B_1,B_2 and C_1,...,C_5 (arranged alphabetical in each group)
When i run the report, it first sorts alphabeticaly for A, then B and last
C. e.i:
A_1
B_2
C_1
C_3
A_2
B_1
C_5
C_2
B_2
C_4
Now, i need for the report to display this data in a non-alphabetic order
(and not just descenting), e.i under A_1 - B_2 i need for C_3 to be displayed
before C_1, or under A_2 i need B_2 to be displayed before B_1, or i need the
entire A_2 group to be displayed before the A_1 group.
Given the fact that there are only finitely many values that need sorting,
is there a simple way in wich to specify an order, e.i. "Order: A_2,A_1" ?

 

[Marshall Barton]

I have made a report in witch i group by 3 fields: A, B
Each of these groups only have finitely many text-values, lets say
A_1,A_2,B_1,B_2 and C_1,...,C_5 (arranged alphabetical in each group)
When i run the report, it first sorts alphabeticaly for A, then B and last
C. e.i:
A_1
B_2
C_1
C_3
A_2
B_1
C_5
C_2
B_2
C_4
Now, i need for the report to display this data in a non-alphabetic order
(and not just descenting), e.i under A_1 - B_2 i need for C_3 to be displayed
before C_1, or under A_2 i need B_2 to be displayed before B_1, or i need the
entire A_2 group to be displayed before the A_1 group.
Given the fact that there are only finitely many values that need sorting,
is there a simple way in wich to specify an order, e.i. "Order: A_2,A_1" ?

I think you need another field in the table (or a related
table) that has a numeric sort specification value. E.g.

text sort
A1 2
A2 1
b1 12
b2 11
C1 62
C2 63
C3 61
C4 64