Traditional web-based reporting with SAS BI tools

Distributing a report in excel format through WRS

Reply
Contributor
Posts: 59

Distributing a report in excel format through WRS

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
SAS Employee
Posts: 238

Re: Distributing a report in excel format through WRS

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
Ask a Question
Discussion stats
  • 1 reply
  • 248 views
  • 0 likes
  • 2 in conversation