Hello.   Our users are using Add-in Office Excel to run a Store Process and generate a dashboard in Excel.   When running the STP, user is prompted to choose between storing the result in a new worksheet or use the current one and specify the cell to use.   No matter which option you choose, Excel open a new worksheet to display the result and the file is always named Main.xlsx   Here is the start of our STP where we specify the name wanted :   %global _odsdest _odsstyle _odsstylesheet; %let _odsdest=excel; %let _odsstyle=sasweb; %let _odsstylesheet=; data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel;'); rc = stpsrv_header('Content-disposition','attachment; filename=BilanDesLits.xlsx'); run; *ProcessBody; %stpbegin;   What's wrong ? Is there another option to set the filename ?   Regards. ... View more

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. ... View more