How do you default Select All with MultiValue Parameter

[Robert]

Using the standalone designer, is there a way to have a parameter's default value set to "select all"  in a MultiValue parameter list?

[Peter]

Hello Robert,

In order to enable multivalue parameters according to your requirements, you have to set the ReportParameter.AllowNull property to false and specify report parameter default value as elaborated in Using Multivalue Parameters help article. You may find useful Extending Report Designer help article that elaborates how to reference an assembly with custom aggregate .

Another option if you have set Parameter.AllowNull property to True and to use report filtering with the following expression:

Expression	Operator	Value
= IIF(Parameters.Param1.Value is null, true, Fields.Fields1 In Parameters.Param1.Value)	=	=true

Regards,
Peter
Telerik

[Ryan]

I also added the screenshots from Telerik Designer.

[Dimitar]

To set all the values as the default value of the MultiValue report parameter, you could indeed use the AllValues or AllDistinctValues aggregate functions.

If there are issues in the web application preview where a report viewer is used, check whether you are not passing a different value to that parameter from the viewer. Values sent from the report viewer will override the default values.