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

How do you default Select All with MultiValue Parameter

1 Answer 729 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Robert
Top achievements
Rank 1
Robert asked on 04 Jun 2013, 08:28 PM
Using the standalone designer, is there a way to have a parameter's default value set to "select all"  in a MultiValue parameter list?

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
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
Top achievements
Rank 2
commented on 03 May 2023, 03:40 PM

I also added the screenshots from Telerik Designer.
Dimitar
Telerik team
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.

Tags
Report Designer (standalone)
Asked by
Robert
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or