We are attempting to achieve the following and would appreciate it if anyone has any insight into how to implement it. A user can run a list containing several columns, but click on a static email to another in-house email application (I'm assuming pl/sql or something on the back-end of Oracle Web Reports. This application reads the emails out to a .csv file from the report location and sends an email. The email piece is completed. We only need SAS piece. Please see below: A SAS Web report is run by a user. The output of this report is actually not just the report results, but a .csv list of emails and names extracted based on parameters in the background (could be multiple parameters) and saved as the report’s actual “report_id” under the user’s ‘My Folder’. There is a static link points to a local in-house email application, which handles the parameter ‘report_id = report’. This report is authenticated by user ID in the application handling, which points us to the proper “My Folder”. 4. The email application reads the “report_id” file under the user’s My Folder into the email server. The user logs onto the email application and then may send an email message to the email address list in the extracted .csv file. So, the two major points we are needing information about are: 1. Does SAS have a stored procedure to extract certain columns as a .csv file from Web Report Studio as the report is run by the user and to place the extracted .csv file into the user’s “My Folder?” 2. Is there a stored process that would assist us in using a static link in the report headers, so every report would have this static link functionality. Below is an example URL: https://local.kennesaw.edu/report_id= 1234abcd.5678edfg As far as the static link, we have been able to work that out using a text box and will suffice vs. in the headers. And, yes, we know that you can export to excel and save to .csv; however, the above functionality is used in one of our campuses with Oracle Web Reports, and we would really like to be able to provide this to our SAS users at our site. Any ideas are most appreciated! sroper
... View more