Traditional web-based reporting with SAS BI tools

Send excel attachment through WRS

Reply
New Contributor
Posts: 3

Send excel attachment through WRS

Hi,

 

Plese help how i will send excel attachment using WRS

 

Thanks,

Prashant Tomar

Occasional Contributor
Posts: 7

Re: Send excel attachment through WRS

Hi Prashant,

 

First let me nderstand what you are looking for

1. Do you need Web report to be sent as attachment?

2. Or Do you want when report run excel file should be e-mailed with attachment?

 

1. this can be done by scheduling report

2. This can be done by calling stored process in web report and which will send email.

     this will be stored process with sas code to send email.

 

Let me know what you are looking for and i can certainly help you on this

New Contributor
Posts: 3

Re: Send excel attachment through WRS

How I will perform this by stored process

2. This can be done by calling stored process in web report and which will send email.

     this will be stored process with sas code to send email.

 

Occasional Contributor
Posts: 7

Re: Send excel attachment through WRS

Here is sample code to send attachment via email FILENAME MailBox EMAIL 'Erik.Tilanus@planet.nl' SUBJECT='Mail message with RTF attachment'; FILENAME rtffile 'e:\testlist.rtf'; ODS LISTING CLOSE; ODS RTF FILE=rtffile; DATA _NULL_; FILE PRINT; PUT "This is my report"; RUN; ODS RTF CLOSE; ODS LISTING; DATA _NULL_; attachment=FINFO(FOPEN('rtffile'),'File Name'); FILE MailBox; PUT "attached you find the report"; PUT '!EM_ATTACH!' attachment; RUN; use this code to create sas stored process to create sas stored process follow this http://support.sas.com/resources/papers/proceedings13/148-2013.pdf and to incluse stp in web report studio follow this https://support.sas.com/documentation/cdl/en/citug/61084/HTML/default/viewer.htm#n1j00mg53d0evfn1t08... and you are done :-)
New Contributor
Posts: 3

Re: Send excel attachment through WRS

Report was already creadted in WRS and wana send report with excel attachment

SAS Super FREQ
Posts: 437

Re: Send excel attachment through WRS

This topic in the SAS Web Report Studio User's Guide explains your options for exporting to Excel.

 

http://support.sas.com/documentation/cdl/en/citug/65926/HTML/default/viewer.htm#p1rwzvqm7l9f9dn1hx7w...

 

You cannot directly email a report as an Excel file. You can email a link to a report snapshot, or you can distribute the report as a PDF.

Ask a Question
Discussion stats
  • 5 replies
  • 379 views
  • 0 likes
  • 3 in conversation