Distributing a report in excel format through WRS

tejeshwar — Tue, 04 Jan 2011 19:26:52 GMT

Hi,

Good Afternoon.

I am planning to distribute certain reports through the WRS in an excel format to certain recipients, however the WRS distribution wizard only has an option to send a report in a pdf or html as an attachment.

Could someone suggest any alternative or if there is a plug-in available to distribute in .xls format as an attachment.

Regards,
Tej

Re: Distributing a report in excel format through WRS

AngelaHall — Wed, 05 Jan 2011 19:22:29 GMT

There is a batch command line scheduling tool (batchgen.exe) available from Web Report Studio that includes an -outputfile option (when using the mode=Extract).

Not sure if it would work, there is some documentation is located here:
http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#a003182446.htm

I havent had an opportunity to use this yet, maybe someone else out there could assist if you have trouble with syntax. You might also consider extracting to html or xml and then having the users open the file into EXCEL.

~ Angela
http://sas-bi.blogspot.com

topic Distributing a report in excel format through WRS in SAS Web Report Studio

Distributing a report in excel format through WRS

Re: Distributing a report in excel format through WRS