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
close icon
If you became a customer of the Syncfusion Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion for your reporting needs.

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 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. 

ML Matt Lawrence June 5, 2019 08:49 AM UTC

Perfect many thanks

VS Vinoth Srinivasan Syncfusion Team 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. 

Live Chat Icon For mobile
Up arrow icon