Dynamically generate an excel from a visual analytics report (viya) through a job (stored process)

[Joy216]

Hello everyone, 

I have been trying to do the following but failed so far if anyone can help out, I would appreciate it: 

I have a visual analytics report. Inside the report I added a text content container and added a hyperlink with the following form :

http:// <sas-server>/SASStoredProcess/?_program=/path_to_sas_program&param1={%1}&param2={%2}&_log=path_to_log/file.log

when I launch this URL alone using a value instead of the placeholder {%1} and {%2} it works and generates the excel as long as i have a local path to my server explicitly precides in my ODS EXCEL FILE= /path/ statement. 

However this is not what I want in the end. the idea is for any user to be able to download the excel output from my sas program by just clicking on the hyperlink. I used the _webout statement:

ods excel file =_webout options(sheet_interval="none"
                                embedded_titles='yes');

 when i run my URL it doesn't work and i just get the content of my first sheet displayed on the webpage.

I must precise that the excel generated is supposed to be dynamically filtered according to param 1 and 2 that take values according to the visual analytics report. although I did put the placeholders I couldn't obtain this. 

two questions here: 

1- how to make this work so that any user from their computer can click on the hyperlink and download the excel?

2- How to configure my URL and macros in sas to dynamically take on their values from the visual analyrics report?

Thank you in advance fo any help provided.

VERSIONS: 

Viya 3.5

Visual Analytics 8.5.2