I went thru the report gen wizard to create a report layout. I am sorting by a field containing a value list. The field I am trying to sort has repititions of four. The report will only sort and select the first choice in the field leaving the others out of my report. Am i going to have to make a field for each choice instead of a field w/many repititions? Have I passed on enough information to be understood?

Thanx

Repetitions can't be sorted...this is another case of the wrong use of something that FMI poorly implemented.

Thanx very much..

Best to replace your repeating fields with a related line items file.