title: Use Search Function instead of using dropdownlist in SSRS
body: <p>Goal:<br />
  Possible to use use search function instead of using dropdownlist in Reporting services.</p>
  <p>Problem:<br />
  Today, the dropdownlist consist of 2500 rows in relation to parameter for prompt.</p>
  <p>You might understand that it is not userfriendly to review and locate a specific information from the dropdownlist by using scroll.</p>
  <p>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?<br />
  In other words, you write something and a result will display instead of reviewing the dropdownlist.</p>
  <p>Info:<br />
  *This is related to reporting services that is part of SQL server</p>
  <p>Thank you!</p>
  <p><a href="https://i.stack.imgur.com/de9mg.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/de9mg.jpg" alt="This is a sample of drowpdownlist for prompt" /></a></p>
  <p>This picture is a sample of dropdownlist.</p>