question

JJTT-0327 avatar image
0 Votes"
JJTT-0327 asked Joyzhao-MSFT commented

Use Search Function instead of using dropdownlist in SSRS

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!


SSRS-Drop-Down-List-Parameters-4.jpg
This picture is a sample of dropdownlist.


sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @JJTT-0327 ,
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.

111195-02.jpg

  • Then please refer to my following steps:

111204-12.gif

Step analysis:
1. Add parameters and set as follows:

111205-03.jpg

2.Dataset properties-Filters-set as follows:
111206-04.jpg
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.



02.jpg (51.5 KiB)
12.gif (970.8 KiB)
03.jpg (40.4 KiB)
04.jpg (27.9 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Complementory.

Is it possible to get a list of propose result based on input data?as dresult based on input data? The result is from dropdownlist in SSRS.

Please take a look at the picture below. Similiar concept as it happening for Google and Bing but for SSRS?

111571-data.png


0 Votes 0 ·
data.png (443.1 KiB)

As far as I know it is impossible.

0 Votes 0 ·