I have had similar issue before, but cannot solve it this time.
See ResultRedundant.jpg for results displayed in my Saved Search.
CRITERIA:
Item : Inactive is false
Item : Location On Hand is greater than 0
Location is any of QUALITY, REPAIRS
RESULTS:
ITEM : NAME
NUMBER
LOCATION
QUANTITY
BIN NUMBER : BIN NUMBER