long param drop down list - can an extension be used to recognize letters you are typing to jump further down the list?

db042190 1,516 Reputation points
2022-10-07T11:51:27.533+00:00

hi we run 2014 currently. 2019 in the not too distant future.

i know ssrs cant recognize in a long param drop down what you are typing and move down the list like a lot of other reporting tools do.

is there a way thru an extension that a drop down can be sensitive to and jump alphabetically per the letters you are typing? I know there is an approach out there where a wild card is entered in a different param but that sounds limiting to me in a mult select scenario.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,826 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Olaf Helper 41,411 Reputation points
    2022-10-07T11:57:50.577+00:00

    You could create an additional parameter with a list of the first letter A-Z to use it cascade to filter the long list of the existing parameter.

    0 comments No comments

  2. db042190 1,516 Reputation points
    2022-10-07T12:52:38.383+00:00

    thx Olaf, thats great in a single select . but i suspect it could get weird in a multi select. and even so, our users would hate it. my head is saying there is an extension language that could be used for one off things like this and i might have even posted the question before. but i cant find it on the web.

    0 comments No comments

  3. Joyzhao-MSFT 15,566 Reputation points
    2022-10-10T05:50:17.58+00:00

    Hi @db042190 ,
    As Olaf said, cascading parameters is an efficient way to shorten the length of parameter dropdowns. If you need to enter letters in parameters and jump in alphabetical order, you may need to consult the development forum for more help.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments No comments

  4. db042190 1,516 Reputation points
    2022-10-10T11:53:45.6+00:00

    thx joyzhao, when you say dev forum are you thinking more OO web development? and suggesting there is no way even to extend ssrs to do something like this?

    or are you talking about a forum that is better suited to discussing "extensions" to ssrs that might cross over into this functionality ?


  5. db042190 1,516 Reputation points
    2022-10-11T12:49:20.593+00:00

    thx, yes the extension i'm thinking about must be more of a special "language" (vb like?) that you can attach as methods/functions to any report and limited to more of a procedural scope . like you said, i do think it has an interactive capability.

    0 comments No comments