Distributing a report in excel format through WRS

[tejeshwar]

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

[AngelaHall]

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