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
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 |
*
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: | 2011-12-09 14:54:29 |
Date Created: | 2011-12-09 14:46:27 |