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?