Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
Problem Note 45101: SAS® Enterprise Guide® and the SAS® Add-In for Microsoft Office might not display crosstabulation tables in SAS® Web Report Studio reports
 |  |  |  |  |
When running with SAS® 9.3, SAS Enterprise Guide 4.3 and later and the SAS Add-In 4.3 and later for Microsoft Office cannot display SAS Web Report Studio 4.31 reports that contain a crosstabulation table based on relational data.
SAS Enterprise Guide displays the following message for each crosstabulation table in the report:
A table in the report could not be displayed
The SAS Add-In displays the following error:
System.NullReferenceException: Object reference not set to an instance of an object. 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)
Click the Hot Fix tab in this note to access the hot fix for this issue. The hot fix is for the first maintenace release for SAS Web Report Studio 4.31.
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.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
| Linux for x64 | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| HP-UX IPF | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| z/OS | 4.31 | 4.31_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||