Problem Note 36113: Tabulated subtotals do not appear after each group in SAS® Report output in the SAS® Add-In for Microsoft Office
In SAS Add-In for Microsoft Office, when you tabulate totals using the SAS Report format, grouped totals appear at the bottom of the tabulated output rather than after each group. If you use an output format such as HTML the totals correctly appear after each group.
As a workaround, you can insert code into the insert custom code section of the task. In order to do this, you must generate the summary table by using Summary Tables task instead of the wizard. In the task, select Preview Code, click the Insert Code button, and then double-click on the first available line in order to insert the following code.
ODS tagsets.sasreport12 options(rolap="on");
|
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
*
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 |
| Topic: | Third Party ==> Products ==> Microsoft Office
Query and Reporting
|
| Date Modified: | 2009-09-09 12:49:30 |
| Date Created: | 2009-06-01 16:16:34 |
