I have an interactive report and was wondering how i can provide addtional filter criteria while not using the search bar that comes with it.
For example i want to be able to add this next to the search bar. Currently I have it on the top in another region. Would prefer to have it below next to the search control.
The following link by Denes kubicek may help you and appears some what similar to your requirement
The idea is to have a dynamic query in your region which returns specific column or all columns
Define and identify column list by select list to choose single or multiple values and return those single or multiple values as per your selection.
The dynamic query then returns the specific columns