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

Select Distinct when using Query Value on Parameters

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?

3 Replies

MS Mahendran Shanmugam Syncfusion Team June 5, 2019 03:00 AM

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. 

ML Matt Lawrence June 5, 2019 03:49 AM

Perfect many thanks

VS Vinoth Srinivasan Syncfusion Team June 6, 2019 12:07 AM

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

Live Chat Icon For mobile
Up arrow icon