I'm guessing that the multi select lookup field comes down looking like
apples; peaches; pears
ie a semi colon delimited text field.
The user can use the filter box at the top to type in a type of fruit or else you would need to make a series of formula checkbox fields to calculate of the fruit contains "apple". So a field called
Apple Yes / no
Peaches Yes / no
Pears Yes/no
But you only get 5 Dynamic filters per reports so it will work if there are less that 5 type of fruits (Stores)
The low tech solution is to put in a report description to explain to users what to type
Also you can explain that typing apples OR Pears with the OR in upper case will get hits on both apples and pears. The OR has to be in upper case. Also AND in upper case will work too but as an AND.
Mark
