Hi I've indented the ParameterCaptions on my parameter lists and it works fine, but there are 100's of levels, so this makes the UI extremely non-friendly to the user. I know that Microsoft has not built in capability to expand or collapse parameter lists, but is there any way to build this in with custom code or by combining it with a different product? Any ideas are welcome. TIA LouisLouis Young

You may try to use RDLC and report viewer combination and have windows forms/web pages based on your requirement. However, this methodology has certain limitations with respect to the functionality that you can achieve with RDL files even from the look and feel perspective. Regards, Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Hi Phani. Thanks. Is RDLC capable of doing multi-value collapsible/expandible parameter dropdowns? Thanks, LouisLouis Young

Hi Phani. Thanks. Is RDLC capable of doing multi-value collapsible/expandible parameter dropdowns? Thanks, Louis Louis Young Hi Louis Young, From your description, you might use a local model report using ReportViewer control. By default, a locally processed report does not have a parameter input area used for selecting or typing parameter values. As ReportViewer control does not execute queries itself. Rather, queries are executed by the host application, and the result is passed to the ReportViewer control. ReportViewer control does not have the opportunity to set query parameters. So if you want to select the parameter from the drop-down list dynamically, you can create a cascaded user control in ASP.NET pages to pass the parameters’ value to T-SQL or store procedure in code-behind to retrieve the dataset for your local report. Regards, Challen Fu

One other option I've investigated is using the SharePoint SSAS filter webpart, but that would mean upgrading from SharePoint Foundation to SharePoint Enterprise. We're still investigating our options.Louis Young

This workaround will openup development of parameters in your ownway in winforms or webforms. RDLC doesnt provide any parameter related customization. Infact in SSRS that cannot be done. Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.