SUPPORT / SAMPLES & SAS NOTES
Problem Note 46931: SAS® Web Report Studio reports that include semicolons in the results fail to open in SAS® Enterprise Guide® and the SAS® Add-In for Microsoft Office
 |  |  |  |  |
SAS Enterprise Guide and the SAS Add-In for Microsoft Office cannot open SAS Web Report Studio reports that include a semicolon in the results. For example, if your results include a value such as Doe;John, then SAS Enterprise Guide presents the following message.
A table in the report could not be displayed
The SAS Add-In for Microsoft Office generates the following error:
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at SAS.Report.Data.DataSource.FormatValues(EmbeddedData data) at SAS.Report.Data.DataSource.LoadEmbeddedData() at SAS.Report.Viewer.Table.LayoutTable(IReportWriter reportWriter, IReportLayout reportLayout) at SAS.AMO.Reports.Table.LayoutTable() at SAS.OfficeAddin.ExcelReports.Table.LayoutTable() at SAS.AMO.Reports.Body.GetMaxTableColumns(Object document, Object renderInfo) at SAS.AMO.Reports.Section.GetMaxTableColumns(Object document, Object renderInfo) at SAS.AMO.Reports.View.GetMaxTableColumns(Object document, Object renderInfo) at SAS.OfficeAddin.ExcelAddin.OpenSASReport(JobContext context) at SAS.OfficeAddin.ExcelAddin.ProcessResults(JobContext context) at SAS.OfficeAddin.OfficeAddinBase.PostProcessJob(JobContext jobContext, Boolean promptOnErrors)
Currently, the only workaround is to remove the semicolon from the results.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: This hot fix is for SAS Web Report Studio.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Solaris for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 |
| Linux for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| HP-UX IPF | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows Vista for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Professional x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows Vista | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| z/OS | 4.3 | 4.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||