Get the text of selected variable

[mattc76]

Hi,

I have a variable populated by data columns I am able to retrieve the Key but also need to retrieve the text(value).

Is this possible?

Thank you

[HighAley]

Hello.

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
If it possible send us an example of problem.

Thank you.

[mattc76]

No problem.

I have created a variable which is populated by a data source.

screenshot1.jpg (58.09 KiB) Viewed 3047 times

On the preview screen the variable generates a dropdown list

screenshot2.jpg (9.78 KiB) Viewed 3047 times

When the user selects an item in the dropdown I would like to return the text of the selected value as well as the key. (i.e. when "Test" is selected in screenshot above return key = 2 AND text = "Test". This is so I can display the selected value on the report as in the example below.

screenshot3.jpg (22.23 KiB) Viewed 3047 times

Thank you.

[HighAley]

Hello.

It's impossible to get value from variable but you could get it using variable. If you set the filter of band to Sites.SiteId = SiteId then you get the Name.

Thank you.

[mattc76]

Ok thanks I have used your workaround and it works.

[HighAley]

Hello.

We are always glad to help you.

Thank you.