Select Expert w/Crystal 7 1

[JillGa]

Using select expert, the operator 'one of', looking at my fields in the drop down, I am not seeing the entire list. Is there a reason for the limit of fields? Are you familiar with the fields that show and which don't show?

 

[EagerBeaver]

I had encountered the same problem a few months back...
Even though all the choices do not show up in the drop down list you can still manually type them in either in the SQL statement or in the select expert.

 

[Andie]

I have heard that you will only see options from the first 100 (or 200?) records in the file. But as "EagerBeaver" pointed out, you can input any valid value from the field.