Hi All, I got a requirement where for one report user needs a search option for prompt. for example prompt for Customer filtering. Drop down list is quite long. instead of drop down list, when user types the related string on the text box it should return the related results. from that user selects what ever he/she wants. looking for you kind suggestion and feedback Thanks a lot in advance.

Hi sqlrich, Instead of search prompt, please use Cascding parameters to filter the items in a parameter. There is no built-in feature like search prompt. Cascading parameters provide a way to filter available values for each parameter in a set of parameters that have a natural relationship. For more information about how to add Cascading Parameters to a Report, please see: http://msdn.microsoft.com/en-us/library/aa337426(v=SQL.90).aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Within SSRS Jim's response is the best you can do. If you need a more customized approach you could easily implement a simple ASP.NET page with a textbox and reportviewer control. Textbox can be set to postback on key press to allow for real time filtering of matching results. Result of textbox entry can be passed to reportviewer control as parameterRgds Geoff

Well, I had implemented a similar report for my customer around 3 years back. What I did at that stage was to use a report parameter, which will be of string data type. Available values will be non-queried (no values will be entered) and the default value would be null. Now when the report starts, you can type in your customer name in this report parameter box. As long as your SQL has a condition like where customer_name=@PAR_Cust_name the report should throw out the correct results. But there are some disadvantages within this, basically the user can enter anything that he wants and sometimes, he might make a spelling mistake and he might be puzzled why data is not being returned when he expects it to be returned.Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)