Problem Note 38967: Error in SAS® Web Report Studio when adding totals or percent of totals to a list table that does not contain any additive measures
 |  |  |  |  |
In SAS Web Report Studio 4.2, if you add totals or percent of totals to a list table that does not contain any additive measures, you will see the following errors when you attempt to display the report.
Missing report element An error occurred in processing the report element. Please refresh the page to try again. Contact your administrator if this problem persists.
The error details will include the following error:
Root Cause: com.sas.iquery.execution2.ExecutionException: Error while submitting SAS code
As a workaround, do not attempt to add totals or percent of totals to a table that does not contain any additive measures.
Change in behavior from version 3.1
In SAS Web Report Studio 3.1, if you attempt to add totals to a list table that contains no additive measures, you see a warning message, and you are not permitted to turn on totals.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | z/OS | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Web Report Studio 4.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B89.html#38967A fix for this issue for SAS Web Report Viewer 4.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B96.html#38967A fix for this issue for SAS Web Report Studio 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D26.html#38967A fix for this issue for SAS Web Report Viewer 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D27.html#38967| Type: | Problem Note |
| Priority: | medium |
| Topic: | Query and Reporting ==> Interactive Querying Query and Reporting |
| Date Modified: | 2010-03-08 16:48:22 |
| Date Created: | 2010-03-08 16:37:24 |