This is a migrated thread and some comments may be shown as answers.

How do you default Select All with MultiValue Parameter

1 Answer 851 Views

Report Designer (standalone)

This is a migrated thread and some comments may be shown as answers.

1 Answer, 1 is accepted

answered on 07 Jun 2013, 11:28 AM

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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Ryan

commented on 03 May 2023, 03:40 PM

Designer-Parameter.png

Designer-Screenshot.png

I also added the screenshots from Telerik Designer.

Dimitar

commented on 08 May 2023, 08:14 AM

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.