We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Select Distinct when using Query Value on Parameters

Thread ID:





145051 Jun 4,2019 10:41 AM UTC Jun 6,2019 05:07 AM UTC Report Platform 3
Tags: Report Designer
Matt Lawrence
Asked On June 4, 2019 10:41 AM UTC

Hi all,

When creating a parameter and selecting the Query Value to populate the Available Values, currently returns every single entry in that field.  Is there a way to effectively group together the same values. i.e. I have 5 records each with a location of London, currently I receive 5 options of London, is there a way to only see 1 but still return all 5 records?

Mahendran Shanmugam [Syncfusion]
Replied On June 5, 2019 08:00 AM UTC

Hi Matt, 

Thanks for your interest in our Syncfusion product. 

Are you asking to create the report with parameter using Dataset query filtering values. If yes, as per the behavior we will get all the values from dataset and will be added for dropdown. You able to create the dataset for parameter with distinct value alone in our Report Designer. 
Please find the below help documentation for your reference. 

Mahendran S. 

Matt Lawrence
Replied On June 5, 2019 08:49 AM UTC

Perfect many thanks

Vinoth Srinivasan [Syncfusion]
Replied On June 6, 2019 05:07 AM UTC

Hi Matt, 
Thanks for your update. Please let us know if you require any further assistance on this. 
Vinoth S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon