I am creating a report in SSRS and viewing it using report manager. The functionality built into SSRS to create parameters is proving fairly limiting. I would like to have something a bit more sophisticated. For example, we have a long list of thousands of product names and a report that takes a product name as a parameter to display sales of that product so I would like a text box that offers autocompletion suggestions when a user types in a part of a product name. I could easily write such a control using ASP.NET and C#, but is it possible to do this and use it within SSRS ? If so, how do I make the properties the control exposes available as parameters when querying my dataset? Kind Regards, Richard

Richard I do not think that is possible. You can use ReportViewer to see SSRS reports.. Put your control on the form,let user to chose needed product name and provide that name a parameter to SSRS reports http://www.codeproject.com/KB/webforms/ReportViewer.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Richard, I am afraid that this feature is not available in SSRS yet, you can vote here http://connect.microsoft.com/SQLServer/feedback/details/582839/ to let MS know. That being said, you can create a parameter, say @ProductSearch and use it in the WHERE clause, something like this WHERE ProductName LIKE @ProductSearch% and then create a second parameter say @Products and populate the available values for this parameter based on the first parameter. So if the user enters Fa in the first parameter, the second parameter will be populated with all the products that begin with Fa. Hope this helps, please let us know if you have nay questions.