How do I set a default value for a multi-value parameter using an expression?

[Wayde]

Following the documentation here:
http://www.telerik.com/help/reporting/designing-reports-parameters-using-multivalue-parameter.html

It says, "In order to have multiple values selected, you should set the Value property of the parameter to an IEnumerable instance containing the desired values. This can be done using the code behind or an expression."

My question is:  How do you specify one or more default values using an "expression"?


Thanks - Wayde

[Elian]

Hi Wayde,

If you use SqlDataSource and follow the documentation step by step (all requirements are satisfied), then you create the aggregate function as shown in the example (may want to change the logic there, which parameters should be selected, as the example selects all).
And then the expression would be Value = AllValues(Fields.YourField). See attached screenshot for more info.

If you are using objectDataSource then you can bind to custom user function that returns an array of data.

Kind regards,
Elian
the Telerik team

[Wayde]

Thanks for the info.  Reviewed the documentation and figured out what I was missing.

As a side note, it would be nice to simply have an option in the designer to have the "<select all>" option in a multi-value parameter set as the default. Using the example it sets it and all other values which is redundant and potentially confusing to end users.

Thanks - Wayde

[Hardik]

I am using standalone telerik report designer Q3 2014. I can't see the function =AllValues.

Could you please advise how can I select multiple values as default? I tried aggregrate function First(),Join() but these functions did not work.

Thanks,
Hardik

[KS]

Hi,

Check this - Using Multivalue Parameters. And to use user functions in the Standalone Designer - Extending Report Designer.

-KS