RS2008R2 Mult_value Parameter parameter choise no selection. NULL can not be selected. select all - too long. I can `t no selection - issues. Make an additional logical option to hide the multi value parameter - do not know how.

Read this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c02370b5-aeda-47ec-a3a8-43b2ec1e6c26/Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing

Hi AlexFilipov, From your description, do you mean how to use parameters to filter the report data or the parmeter has too many values and make it inconvenient to select values? If you want to use a multivalue parameter to filter the report data, you can add a filter to a dataset/data region/group, or add a where clause in the dataset query. For multivalue parameter, we need to use the "In" operator. For the detailed information, you can refer to the thread Uri recommended. If there are too many available values for the parameter and you want to make it easier to select the values, we may use the cascading parameters. That is to say we can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter. For more information, you can refer to the following thread and article: How to: Add Cascading Parameters to a Report Regards, Mike YinMike Yin TechNet Community Support