Use Search Function instead of using dropdownlist in SSRS

Question

Goal:
Possible to use use search function instead of using dropdownlist in Reporting services.

Problem:
Today, the dropdownlist consist of 2500 rows in relation to parameter for prompt.

You might understand that it is not userfriendly to review and locate a specific information from the dropdownlist by using scroll.

Does SSRS provide a function that you can write in a textbox something similiar and it will display the result based on the data from dropdownlist?
In other words, you write something and a result will display instead of reviewing the dropdownlist.

Info:
*This is related to reporting services that is part of SQL server

Thank you!

This picture is a sample of dropdownlist.

Answer 1

Hi @JJ TT ,
If I understand correctly, you want to manually enter the parameters for query.
I did a test locally:

• First of all, I have a very simple Table in VS.

• Then please refer to my following steps:

Step analysis:

1. Add parameters and set as follows:

2.Dataset properties-Filters-set as follows:

Hope this helps. If I misunderstand what you mean, please feel free to correct me.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.