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

Sorting Join() of MultiValue-Parameter

2 Answers 465 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Diego
Top achievements
Rank 1
Diego asked on 08 Sep 2017, 08:10 AM
Hello,

I show the selected values from an ASC sorted MultiValue-Parameter with

Join("; ", Parameters.param1.Label).

But I have the problem that the displayed values aren't sort. They are in the order as I have selected them before in the Multi-Value-DropDown.

How can I sort the displayed values?

Thanks.

Regards,
Diego

2 Answers, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 12 Sep 2017, 10:45 AM
Hello Diego,

Indeed the values from a sorted MultiValue Parameter when displayed with Join function appear in their order of selection since this is the order they have been added to the collection. This behavior is by design.

If it is necessary to show the chosen parameter values sorted, a sorted collection should be passed to Join function. I would suggest you to create a custom sorting function and use it to sort the values before joining them, i.e. something like:
Join("; ", CustomSort(Parameters.param1.Label)).

I hope this would help.

Regards,
Todor
Progress Telerik
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
0
Todor
Telerik team
answered on 12 Sep 2017, 12:15 PM
Hello Diego,

Just to add that in order to use custom functions in expressions you can follow this article.

Regards,
Todor
Progress Telerik
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
Diego
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or