sorting and grouping

  • Thread starter Thread starter gal
  • Start date Start date
G

gal

Hi group,

I have a combo box in a report that produces complexity
level-Very High, High, Medium, LOw.

The current order is - HIgh,Medium,Low,VetyHigh (ascending)
I want to change it to- Very High, High,Medium,Low

The Soring and Grouping option doesn't give me the choice
(it's eihter Asc or Desc)

How can I do that?
 
I would recommend to change the combo box source to a
table with two columns
1st column 2nd column
Very High - 1
High - 2
Medium - 3
Low - 4
now set the ascending order to the second column,
and the bound column to the first.
That should solve the problem.
Hope this helps.
Fons
 
gal said:
I have a combo box in a report that produces complexity
level-Very High, High, Medium, LOw.

The current order is - HIgh,Medium,Low,VetyHigh (ascending)
I want to change it to- Very High, High,Medium,Low

The Soring and Grouping option doesn't give me the choice
(it's eihter Asc or Desc)
Click to expand...

Ideally, you should have a little table with fields for the
complexity number and text. The combo box can display the
text while it stores the number that would use for sorting.

Lacking that, you have to use a messy expression to
sort/group:

=Switch([Complexity]="VeryHigh", 1, ([Complexity]="High", 2,
([Complexity]="Medium", 3, ([Complexity]="Low", 4)
 
Back
Top