Multiple Default Values for MultiSelect Parameter

[Phil]

I have a multi-select parameter where I want to set 2 default values (MTD, YTD).  The parameter dropdown allows the user to select which periods they would like to view.  For Each Organization, the periods have different ID's and can have different names.  But there are some commonalities.

Some orgs use YTD, some use FYTD.  SO I need to be able to set my default value something like:

               = Array(Field.ShortName Like '%YTD%' OR Fields.ShortName Like '%MTD%')

However, I have tried this and it does not work.  Does anyone know a solution for this?

Thanks,

Phillip

     

[Phil]

I also tried this:

= IIf(Fields.ShortName Like "%MTD%" OR Fields.ShortName Like "%YTD%", Fields.PeriodId, Null)

This only selects the top value from the parameter dropdown.

[Stef]

Hi Phil,

Please check the Using Multivalue Parameters article, and test the approaches where you can list the IDs (ValueMember) of the desired displayed values, or you can use a custom function to get their IDs.

I hope this information is helpful.

Regards,
Stef
Telerik