I am using SAS Information Delivery Portal 4.2 to display a stored procedure in a SAS Stored Process Portlet. I included a refresh button to update the stored procedure each time the user changes a dropdown option. The user experiences an extra login that I would like to remove.
First the user logs into SAS Information Delivery Portal 4.2 where the user is prompted for credentials. Then the user clicks on the tab containing the portlet. The stored procedure shows correctly. The user changes a dropdown parameter. The user clicks refresh. The stored procedure calls a postback method and reloads the page. Only on the first time the page refreshes is the user prompted for credentials, clicking refresh again will not prompt the user.
The post back call is:
PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";
The driver method is
/*driver function for displaying the form*/
%MACRO DisplayForm();
DATA _null_;
FILE _WEBOUT;
PUT "<html>";
PUT "<body>";
PUT "<div style='font-family: Verdana; font-size: 8pt;'>";
PUT "<CENTER>";
PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";
PUT "<input type='hidden' name='_program' value='/Users/User_Name/My Folder/Stored Procedure Name' />";
PUT "<input type='hidden' name='_action' value='EXECUTE' />";
DATA _null_;
file _webout;
PUT "<tr>";
PUT "<td colspan='2'>";
PUT "<input type='submit' style='font-family: Verdana; font-size: 8pt;' class='button' value='Refresh' />";
PUT "</td>";
PUT "</tr>";
Run;
%ProcessReport();
DATA _null_;
file _webout;
PUT "</table>";
PUT "</FORM>";
PUT "</CENTER>";
PUT "</div>";
PUT "</body>";
PUT "</html>";
file _webout;
RUN;
%MEND DisplayForm;
