Cascading Parameter Multivalue Label

[John]

I have a report parameter that as its available values has a stored proc, which returns a set of (ID, Name) records.
The is a multi value parameter, so the user selects 1 or more of the items in the list.
So far so good.
The selected IDs are then passed to a Stored Proc when the report is rendered, and all is well and good.
However...In the header of each page, I want to show the parameters that were used, but not the IDs, the Names.
You can only really use parameters in the header.
So basically I want a second parameter to get the concatenated list of Names selected from the first parameter.

For instance, if the data set is

17 Oslo
22 Stockholm
31 Copenhagen

And the user selects Oslo and Stockhom, then the report sp is passed 17, 22, but I want the header to show "Oslo, Stockholm", not "17, 22".... And as an additional constraint this is for a TRDX with no C# coding.

[Nasko]

Hello John,

Thank you for contacting Telerik Support.

When setting up multivalue report parameters you can specify which data fields to use for a ValueMember and DisplayMember of the report parameter.
If you want to use the names of the cities, you should set them as the DisplayMember​ and later use Parameters.Parameter1.Label in the report header expressions: screenshot.

I will be happy to assist you if you have further questions.

Regards,
Nasko
Telerik

 

 

[John]

I think you might be missing my point. I do understand what the ValueMember and DisplayMember are, and nothing is a problem there. Let me repeat my problem below

For instance, if the data set is

17 Oslo
22 Stockholm
31 Copenhagen

And the user selects Oslo and Stockhom, then the report sp is passed 17, 22, but I want the header to show "Oslo, Stockholm", not "17, 22".... And as an additional constraint this is for a TRDX with no C# coding.

So, in parameter 1, I have in effect selected 17,22, which the report needs to render.
But at the same time I need to show "Oslo, Stockholm" in the header of the report.

How do I do that?

[John]

I solved this one myself.

In the header, I have a text box with the Value:

=Join(", ", Parameters.CityList.Label)

CityList is a multi value parameter bound to a StoredProc.

With this setup, the parameter correctly passes a list of CityIDs to the report, and the header shows the names of the cities chosen.