topic Interactions between drop-down list and stored process or embed HTML page with javascript in VA 7.4 in SAS Visual Analytics

Interactions between drop-down list and stored process or embed HTML page with javascript in VA 7.4

CHUNantes — Mon, 27 Apr 2020 13:28:48 GMT

Hello.

We need to develop a VA report and in one tab, we want to display URL links so users can download XLSX files.

In this tab, there is 3 zones : Text, Dop-down list and Stored process :

The difficulty is that we need to generate specific URL link depending on the value selected in the Drow-down list.

We didn't find a way to make an interaction between Drop-down list and Stored process (to call the STP with Drop-down list selected value as parameter).

Is it possible to make such an interaction ?

If not, we can write a HTML page with some javascript code to display a drop-down list and generate the links but how can we embed this HTML page in the VA report ?

Or maybe there is another way to solve our issue.

Thanks for your help.

Re: Interactions between drop-down list and stored process or embed HTML page with javascript in VA

Sam_SAS — Mon, 27 Apr 2020 20:07:03 GMT

In VA 7.5, you can display an HTML page in your report by using a Web Content object. I don't think this object is available in 7.4, unfortunately.

Re: Interactions between drop-down list and stored process or embed HTML page with javascript in VA

CHUNantes — Tue, 28 Apr 2020 07:19:54 GMT

Thanks.

For now, we have found a work-around by creating a tab for each value displayed in the drop-down list and each tab display the result of the stored procedure with a different parameter.

But as we will upgrade to SAS 9.1 TS1M6 and VA 7.5 this summer to avoid using Flash GUI, it's a great news to know that Web content object exist.