Report sort order from list field

[john3588]

I have a field that was populated from the following look-up list - Forcast/Concept;Sources Sought;Sources Sought Submitted;Awaiting RFP;Proposing;Submitted for Review;Drop;Won;Lost. I need to print a report in the following order:
Forecast / Concept


Sources Sought
Sources Sought Submitted
Awaiting RFP
Proposing
Submitted for Review.
and the report excludes the last three in the list (drop - won - lost)
Since the field data is being selected from a list and not a table I can't come up with a good way to sort the report for printing in the correct order. There is a second sort order by bid date after the sort criteria above is chosen. .

[June7]

Let x represent the field. Create a sort value field with expression in query:

SortNum: Switch(x="Forecast/Concept",1, x="Sources Sought",2, x="Sources Sought Submitted",3, x="Awaiting RFP",4, x="Proposing",5 x="Submitted for Review",6)

[john3588]

Worked perfectly - did not know there was a "switch" function. Very nice.

[June7]

There is also a Choose function you might want to get familiar with.