Distinct values from Multivalue Parameter

[Bharathi]

Hey there, 

I am trying to get the list of distinct values from a parameter which is of multivalue select.. Here is the exact scenario:

I have filter on my report table which takes a multivalue parameter.. This parameter is directly bound to one of the columns in report datasource.  Now I need to access these multivalue parameter list outside of my table( in footer). The problem started when I attempted to get the distinct list of values in that parameter.. 

I could simply use =Join (", ",=Parameters.MyParam1.Value) which would concatenate all the values, but since the filter is directly bound to the report's data source, it returns duplicate values.

For example, when I set the value for MyParam1 to 'Gold', 'Silver', the parameter holds duplicate number of values depending upon number of rows in the report table.. 

How can I get around this to get the distinct values from MyParam1?

[Stef]

Hello Bharathi,

I am uncertain about the settings of the report.
If the available values of the report parameter contain duplicating values in the Parameter>AvailableValues>ValueMember, the viewer's editor for multivalue parameters will display only the distinct values.

If the issue is related to filtering data, please check How to use MultiValue Report Parameter in a SQL query. The KB article includes examples with SQL statements and parameters settings.


In order to provide you more accurate suggestions, please post the settings of the SqlDataSource component and report parameters in the report.

Regards,
Stef
Telerik by Progress