Select Distinct when using Query Value on Parameters

[Matt Lawrence]

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]

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. 

https://docs.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-report-builder?view=sql-server-2017 

Regards, 

Mahendran S. 

[Matt Lawrence]

Perfect many thanks

[Vinoth Srinivasan]

Hi Matt, 

 

Thanks for your update. Please let us know if you require any further assistance on this. 

 

Regards, 

Vinoth S.