Problem Note 46845: Exporting selected columns might not work in SAS® Web Report Studio
SAS Web Report Studio enables you to export selected columns from list tables. When exporting to Microsoft Word or Microsoft Excel, the document or spreadsheet might be blank. When this problem occurs, the SAS Web Report Studio log contains an error similar to the following:
2012-06-06 11:42:46,976 [http-0.0.0.0-7070-5] ERROR
[68f13a58a01f9498:36ac2c09:137beb36ac3:8d4o686081]
com.sas.apps.citation.view.tbeans.commands.export.ExportTableCommand -
java.lang.IllegalArgumentException: Invalid column index.
at
com.sas.servlet.tbeans.tableview.DefaultTableColumnModel.getColumn(DefaultTableC
olumnModel.java:176)
at
com.sas.servlet.tbeans.tableview.BaseTableView.isExportNumericCustomFormattedVal
uesAsText(BaseTableView.java:4682)
...This problem occurs under very specific circumstances. For example, if you select a mixture of category and measure columns but you do not include the first column, then the export fails. However, if you select a mixture of category and measure columns but you do include the first column, then the export succeeds. In addition, exporting measure columns succeeds regardless of their position in the table.
As a workaround, you can export the results as tab-delimited or comma-delimited data.
Operating System and Release Information
| SAS System | SAS Web Report Studio | z/OS | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Enterprise 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Enterprise x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Home Premium 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Home Premium x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Professional 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Professional x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Ultimate 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Ultimate x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows Vista | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows Vista for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled Solaris | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| HP-UX IPF | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Linux for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Solaris for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-06-19 12:36:15 |
| Date Created: | 2012-06-19 12:25:49 |
