1 of 1 people found this helpful
Hi Matthew! What you can do is create an integer parameter that allows people to search. For instance, let's say your parameter is called [Search]. Then, you would create this calculated field for filtering:
[Search] = [Store #]
Filter in the true values.
EDIT: I completely misunderstood how this worked at first. Different solution posted.
Your solution gave me the ability to search store numbers without quotes. Awesome! The issue is when the workbook opens it just shows a single store number which is coming from field "current value" in the search parameter. By default I need to show all store numbers when opening. Also if I search a single store then delete my search criteria I need all stores to show back up.
Oh, gotcha! Change the formula to this:
[Search] = [Store #] OR [Search] = ""
This will show all values when [Search] is blank.
Also, you'll want to change Allowable Values to "All" and make sure that the Search parameter is blank when you save or publish the workbook.