Hey all... I currently have a multi-value parameter which has a really long list of values, the problem is users are forced to scroll through this list to find the value that they want. Is there a way to allow users to type the value and the list might "jump" to that character in similar fashion to the single select drop down box? I have thought about trying to implement different work arounds, but i have come up with nothing. My list is a long list of store codes which 99% of the time a user would only select 1. However, the area managers need to select multiple stores. 1 work around was to provide them with a free text box however this looks messy and occasionally users need to scroll to find there store as they don't know the store code. I thought about putting both input parameters type on the page except you can not leave a multi-value parameter blank (if a user had typed the store code into free text)... Any ideas?

I'm guessing not by the lack of response.

You could, though, set it up to default to the value of their location, which would help those 99% of users. Create a new dataset for thereportwhich retrieves the users location. In your parameter with the huge drop down box, set the default values to 'from query', using the dataset you just created to set the default to the users location.

The catch is that they will be accessing this report via the internet so they won't be authenticating.

hmm, but they would still have to logon to your network, even via the internet wouldn't they? otherwise any Tom, *** or Henrietta in the world could run your reports. the global UserID variable has their network authentication credentials which can then be used within the report.

Well yeah, its not quite that open but the users aren't on our primarydomain and will either be using a generic login or an anonymous login.

I am not sure but you can organize the parameter SQL using like expression: Code Snippet Select StoreName from Stores where Store Name Like @StoreTextInput and bind it to second multival parameter.

bmalar,I had a similar problem where users would have to search through a dropdown containing hundreds of values just to get to a single one. The solution we opted for was a series of smaller reports that would allow users to drill down to the info they need. Started with a generic list of all our clients, from which the user would select one. That selection would link to another report, which would display all the products marketed by that client using the client that the user selected in the previous report as a parameter. The user continues to click down in similar fashion: the products list drills into the project list for the user-selected product, and from that list (reduced from hundreds to maybe 10 or so) the user selects the project they want to run the report on.It might seem a bit cumbersome, but I've had a lot of positive feedback from the users, and not a single one has said they prefer scrolling through that dropdown list :-)As for your users who need to view multiple stores, unless they need to view them all at the same time, the above solution allows you to return to the original report to make a different selection at any step. Otherwise, you may want to consider creating a separate report just for the area managers....

What about grouping the store codes somehow, for example by the first (or first few) values in the store code? Then allow them to select the group in the first parameter and cascade the result to the Store Code paramenter to give them a shorter list of Store Codes to choose from.Martina White