In Search and Report wizard or in creating views at right hand site there is option of putting values which happens to be fixed. But like other database there should be option of selecting value dynamically either by query from tables or by variables as right hand side value for comparison. Also there should be option for "in" or similar operator to match all or any value from the list