Page 1 of 1

Get the text of selected variable

Posted: Tue Jul 31, 2012 3:22 pm
by 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

Re: Get the text of selected variable

Posted: Wed Aug 01, 2012 5:03 am
by 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.

Re: Get the text of selected variable

Posted: Wed Aug 01, 2012 8:52 am
by mattc76
No problem.

I have created a variable which is populated by a data source.
screenshot1.jpg
screenshot1.jpg (58.09 KiB) Viewed 3043 times
On the preview screen the variable generates a dropdown list
screenshot2.jpg
screenshot2.jpg (9.78 KiB) Viewed 3043 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
screenshot3.jpg (22.23 KiB) Viewed 3043 times
Thank you.

Re: Get the text of selected variable

Posted: Wed Aug 01, 2012 1:21 pm
by 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.

Re: Get the text of selected variable

Posted: Thu Aug 02, 2012 3:54 pm
by mattc76
Ok thanks I have used your workaround and it works.

Re: Get the text of selected variable

Posted: Fri Aug 03, 2012 12:23 pm
by HighAley
Hello.

We are always glad to help you.

Thank you.