how can I make a multivalue dropdown parameter also editable to select faster?

• Cindy123

  SSC Journeyman

  Points: 78

  More actions

  January 28, 2017 at 12:58 am

  #321114

  Hi,
  I'm fairly new to SSRS reporting and have setup a report with a multivalue parameter which is a list of customers (account number and name) for the user to select from.  The multiple selections are passed to a stored procedure  (using the join expression in the parameter call to procedure and parsed back out for my sql select within the procedure) and return a result to my report.  All of that is currently working beautifully. 

  My issue is that the parameter list of customers is very large and it is time consuming for the users to scroll through this list to find particular customers and click on the checkbox to select each customer they want.  I want them to either be able to type the customer numbers in the parameter selection if they know them or choose to click on the checkboxes to select if they are going to scroll through the list of customers.  It could even just be the entry would scroll the drop down directly to the customer so they can click on it, but that would not be my ideal solution. 

  I have looked everywhere and can't seem to find a property to set to enable editing along with the checkboxes or any way to 'scroll to the entered text' or anything remotely close to that. I would think it would be a standard feature with multivalue parameters and maybe I'm just missing something obvious but I can't seem to find it.  Please help - I really need to be able to do this.

  Thank you!
  CLN