This is a migrated thread and some comments may be shown as answers.

Distinct values from Multivalue Parameter

1 Answer 135 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Bharathi
Top achievements
Rank 1
Bharathi asked on 10 May 2017, 05:12 AM

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?

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 12 May 2017, 01:43 PM
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
Tags
Report Designer (standalone)
Asked by
Bharathi
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or