You may be able to get away with that doing a summary criteria to only show where the summary of

Location On Order

is not greater than zero… not sure if quotes would trigger

on order

..