Distinct values from Multivalue Parameter

2 posts, 0 answers
  1. Bharathi
    Bharathi avatar
    1 posts
    Member since:
    Aug 2016

    Posted 10 May 2017 Link to this post

    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?

  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 12 May 2017 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top