Traditional web-based reporting with SAS BI tools

Export of report in xls

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Export of report in xls

Hi,

I am using SAS Web Report Studio 3.1. I need to export a report in xls format. I am able to export individual tables or graphs in xls via the export functionality, however when I export the compete (all tables and graphs in the report ) report I am asked to save a .zip file. This when opened throws errors saying missing files and excel is empty.

Please advise way out.


Accepted Solutions
Solution
‎04-24-2015 04:57 AM
New Contributor
Posts: 4

Re: Export of report in xls

Thank you for the response. I am now able to view the report in excel.

View solution in original post


All Replies
SAS Super FREQ
Posts: 381

Re: Export of report in xls

You must extract the files before you can open them. Please see this SAS note for more details: 32241 - When exporting a report from SAS® Web Report Studio, you must extract the files before you c...

Solution
‎04-24-2015 04:57 AM
New Contributor
Posts: 4

Re: Export of report in xls

Thank you for the response. I am now able to view the report in excel.

New Contributor
Posts: 4

Re: Export of report in xls

Hi,

I have the below issues -

1. After export to xls if the report contains many charts they tend to overlap each other and the formatting of headers for those charts is also changed.

2. The values for a cross tab are appearing in a different format when viewed in excel. However when the table is separately exported the original format as seen in Web Report Studio is retained.

Kindly advise solutions to the above?

SAS Super FREQ
Posts: 381

Re: Export of report in xls

Post a Question
Discussion Stats
  • 4 replies
  • 881 views
  • 1 like
  • 2 in conversation